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