Yahoo, It is working. Thank you.
--
pls


"Sheeloo" wrote:

For days_late, thry this in FORMULA IS
=AND(days_late0,days_late<" ")

"Pat" wrote:

I have read & tried several CF solutions, but they are not working for me.
I am working with Today() date, Due_Date, & days_late.

I have a formula in the days_late column
=IF(OR(TODAY()<Due_Date,J9="COMPLETED")," ",TODAY()-Due_Date). This formula
gives me days_late or leaves that column blank (" ").

I want 5 cells to turn red if days_late1. All my attempts at CF have also
turned the blank (" ") cells red also. I have tried ISBLANK and NOT(ISBLANK).
--
pls