Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting yet again
Here are three columns on my spreadsheet:
E F J Reference Date Report Due Date closed When a client is opened, that date is entered into E2 and the formula in F2 is =E2+60 to indicate that the report should be done in 60 days. Using conditional formatting, I have set the F column to change the text color after 90 days to warn that a client is overdue for closing. That works fine, but if a client has already been closed -- that is if there is a date in column J, don't want the text in column F to change color. Anybody got a formula for me that can do that? Ross |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |