Conditional Formating and Formula

[Guest]

Hello I have the following formula in a cell =IF(W3-V3=0," ",W3-V3). I'm
trying to conditional format all cells that have an answer and I used the
following formula in the conditional format window =$X2<>0 . And it
highlight the cell . How do I correct this I thinki t has to do with the if
formula and " " but i dont know how to correct it thanks

 

[PCLIVE]

It's hard to understand what you want, exactly. I assuming the IF formula
is in X2. If you want cell X2 to change color when it does not equal zero,
then in conditional formatting for that cell:

Cell Value Is
not equal to
0


Note you can select multiple cells when applying this formatting.

HTH,
Paul

 

[Guest]

try getting rid of the space between the Quote marks "" instead of " "
make you conditional formula be <>""

 

[Gord Dibben]

Your formula returns a <space> if W3-V3 is zero so it will always be <>0 and be
highlighted.

Perhaps change the " " to "" for blank and use =$X2<>""


Gord Dibben MS Excel MVP

 

[Guest]

If you want the cell blank when equal to zero, it's not necessary to add a
space, try this instead:
=IF(W3-V3=0,"",W3-V3)
and set your conditional format to:
=$X2<>""
or
=$X2<>" "
if you prefer your original formula.
"" is called a zero length string - a string that contains no characters.

 

[Guest]

If you don't want to show anything when a formula returns zero, you could
just select Tools >> Options >> View and uncheck the Zero values checkbox.
Then your original conditional formatting formula should work (or you could
choose "Cell value is", then "not equal to", then 0).

Hope this helps,

Hutch