Conditional Formating and Formula
 

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

Conditional Formating and Formula
 

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


"Wanna Learn" wrote in message
...
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

Conditional Formating and Formula
 

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

"Wanna Learn" wrote:

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

Conditional Formating and Formula
 

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

On Fri, 4 May 2007 08:15:01 -0700, Wanna Learn
wrote:

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

Conditional Formating and Formula
 

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.

"Wanna Learn" wrote:

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

Conditional Formating and Formula
 

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

"Wanna Learn" wrote:

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