Conditional Formatting

  • Thread starter Thread starter Trying Hard
  • Start date Start date
T

Trying Hard

Since there is already a formula in this cell, I am trying
to use conditional formatting to say If this cell value is
equal to the word Null, then just leave it blank. Is this
the correct syntax?

Thanx

=IF(H2="Null","")
 
You should do it this way:

- Choose Format>Conditional Formatting
- Use 'Cell Value Is' and 'equal to'
- Type the word Null in the third box. (You don't need
quote marks. It will put them for you.)
- Click the format button and choose White for White for
Font Color.

tod
 
I considered this but I did not want to simply hide it, I
don't want to show it all...can I just leave it blank?

Thanx
 
Here is the formula in H2 =IF(ISERROR(VLOOKUP
(H2,Tivoli,7,FALSE)),"",MID(VLOOKUP
(H2,Tivoli,7,FALSE),1,12))

This brings me back a value for instance APPLICATION...now
it could also bring me back NULL....Null for my purpose
means nothing so I don't want to show it...

Thanx



-----Original Message-----
----- Trying Hard wrote: -----

Since there is already a formula in this cell, I am trying
to use conditional formatting to say If this cell value is
equal to the word Null, then just leave it blank. Is this
the correct syntax?

Thanx

=IF(H2="Null","")

What cell are you putting this formula in (conditional
Click to expand...
formatting dialog box)? Do you have a (different) formula
in H2, which will possibly evaluate to "Null", which you
don't want to display? If so, maybe this will work
 
Back
Top