|
Conditional
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 |
Conditional
I can use conditional format
Cell Value IS Equal Use the Formula Is option and it will work. -- Biff Microsoft Excel MVP "RKS" wrote in message ... 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 |
| All times are GMT +1. The time now is 03:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com