| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| Conditional Rank (or rather, Conditional Range) | Excel Worksheet Functions | |||
| Conditional IF to use or / and | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
| Conditional sum | Excel Worksheet Functions | |||
Hybrid Mode
