conditional formating

C

Cheryl

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.
 
T

T. Valko

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.
 

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

Similar Threads

Comparing two columns with conditional formatting 4
Date diffrence in days, weeks and months. 1
Data Validation List 1
Conditional formatting with dates 7
Conditional formatting with two columns 0
Copy and Paste Word 2010 0
Need help adding a formula to to cell with conditional formatting 3
Dates and if statements 3

Top