Conditional formatting

G

Guest

I am trying to do the following:

1. In cell H14, if the cell is blank, turn blue.
2. In cell H14, if the cell has a date less than or equal to another cell,
turn green.
3. In Cell H14, if the cell has a date greater than another cell, turn
orange.
4. If NA is placed in the cell, revert to no format.

I have managed the first three, but cannot get the fourth one to work. What
formulas should I be putting in Each condition?
 
G

Guest

Hi Christina-

You might want to check back in the thread to your original post on this
issue. There just may be something there that is useful!|:>)
 

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

Similar Threads

I need help on conditional formatting. 2
Conditional Formatting - Excel 2003 2
Writing Formula For conditional Formatting Using Excel 2000 3
Conditional Formatting 4
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Conditional formatting with formulas 6
Conditional Formula formatting 2
several conditional formats for dates 4

Top