OKAY..last question... is there a way to make the function recognize the date
but make the whole row the color i format it to be instead of just the cell?

"Max" wrote:

Apply the 3 cond format formulas below in sequence:
Cond1: =AND(C1TODAY(),C1-TODAY()<=30,C1<"")
Cond2: =AND(C1TODAY(),C1-TODAY()<=60,C1<"")
Cond3: =AND(C1TODAY(),C1-TODAY()<=90,C1<"")
Format the trigger fill colours for Conds 1 to 3 as desired
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kate" wrote:
thank you.. that did help.. okay.. i have another question... is there a way
to make 30 days one color 60 days another color and 90 days another color?
you are such a big help!!!!!