| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thanks Bob,
Worked like a charm Ross "Bob Phillips" wrote in message ... =AND(J2="",E2+90<=TODAY()) I am assuming your current CF formula is =E2+90<=TODAY() -- HTH Bob Phillips "Ross" wrote in message ... 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 |
| Reply |
| 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) | |||
Hybrid Mode
