Conditional Formatting

[AL]

I'm attempting shade cells using the conditional formatting option.
The conditions I am using are as follows...
If cell X is greater than cell T then shade green.
If cell X is less than cell T then shade red.
If cell X is equal to cell T then shade blue.

These conditions have been applied to a particular column.

The issue is that if the cell has no value at all it shades red. I do not
want this to happen as data has not yet been gathered for this cell.

Any solutions or ideas?

 

[Luke M]

Change the red condition to:
Formula is:
=AND(isnumber(cellX),Cell_X<Cell_T)

 

[David Biddulph]

CF/ Formula Is: =AND(X2<>"",X2<T2)

 

[AL]

Works great! Now a similar question and hopefully my last. I have a column
that calculates the difference between Cell X and Cell T.

My conditional formatting is set as follows....

If cell Y is greater than 0 then shade green.
If cell Y is less than 0 then shade red.
If cell Y is equal to cell T then shade blue.

The blank cells automatically shaded green. I tried tweaking your formula to
Formula is =AND(ISNUMBER(Y3),Y3>0) for the green shading.

It took care of the blank cells turning green but also stopped the >0 cells
from turning green.


Thank you for your help!

 

[AL]

Correction:

"If cell Y is equal to 0 then shade blue."