Conditional Formatting


A

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?
 
Ad

Advertisements

A

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!
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top