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

=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

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