View Single Post
  #1   Report Post  
Ross
 
Posts: n/a
Default 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