Conditional

R

RKS

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top