Conditional Formatting
 

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?

Conditional Formatting
 

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

Luke M
*Remember to click "yes" if this post helped you!*


"AL" wrote:

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?

Conditional Formatting
 

CF/ Formula Is: =AND(X2<"",X2<T2)
--
David Biddulph

"AL" wrote in message
...
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?