Hi,
Thanks in advance.
Please tell me what we wrong and how is its working proper
( Condition is - If C1 is blank and B1 is less than or equal to today then
its red colour)
otherwise normal colour. But its not working.

A B C
1 01/01/06 A1+30 day


I have 3 column A,B and C. In col B date comes from Col A+30 days

I can use conditional format
Cell Value IS Equal =AND(B1<=TODAY(),ISBLANK(C1)) then RED

Please give solution.
Thanks
RKS