conditional formating
I have the following formula for column D and E
=D2<Today() red =(D2-Today())<30 green I need to add a formula that if a date is in column c then column D and E are black. |
conditional formating
What are you formatting? The font color or the cell fill color?
-- Biff Microsoft Excel MVP "Cheryl" wrote in message ... I have the following formula for column D and E =D2<Today() red =(D2-Today())<30 green I need to add a formula that if a date is in column c then column D and E are black. |
conditional formating
The font color.
"T. Valko" wrote: What are you formatting? The font color or the cell fill color? -- Biff Microsoft Excel MVP "Cheryl" wrote in message ... I have the following formula for column D and E =D2<Today() red =(D2-Today())<30 green I need to add a formula that if a date is in column c then column D and E are black. . |
conditional formating
Ok, if you're formatting the font color then the default font color should
be black. So, you'd just need to modify your current formulas. =AND(COUNT(C2)=0,D2<Today()) =AND(COUNT(C2)=0,D2-Today()<30) The logic is: If C2 contains a date (which Excel evaluates as a number) then the formula will evaluate as FALSE and the red or green font color *will not* be applied leaving the default black font. -- Biff Microsoft Excel MVP "Cheryl" wrote in message ... The font color. "T. Valko" wrote: What are you formatting? The font color or the cell fill color? -- Biff Microsoft Excel MVP "Cheryl" wrote in message ... I have the following formula for column D and E =D2<Today() red =(D2-Today())<30 green I need to add a formula that if a date is in column c then column D and E are black. . |
All times are GMT +1. The time now is 02:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com