Conditional Formatting yet again

[Ross]

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

 

[Bob Phillips]

=AND(J2="",E2+90<=TODAY())

I am assuming your current CF formula is =E2+90<=TODAY()

 

[Ross]

Thanks Bob,
Worked like a charm
Ross

=AND(J2="",E2+90<=TODAY())

I am assuming your current CF formula is =E2+90<=TODAY()