Conditional Formatting - 2 conditions

  • Thread starter Thread starter Otto Moehrbach
  • Start date Start date
O

Otto Moehrbach

Excel XP & Win XP
I thought this was easy but it isn't.
I want to apply conditional formatting to D1 so I have D1 selected.
I want 2 conditions to be true before the formatting is applied. They are:
(Note that D1 holds a date).
D1 > Today()
E1 <> "YES"
I tried:
Formula is:
=If(And(D1>Today(), E1<>"YES"))
Excel adds quotes as:
="If(And(D1>Today(), E1<>""YES""))"
But the formatting is not applied.
What am I doing wrong? Thanks for your time. Otto
 
Take the extra quotes out. If you put the = in at the beginning of the
formula as you enter it, I think you'll find that CF won't add the extra
quotes.
And you don't want IF.
All you need is =AND(D1>TODAY(), E1<>"YES")
 

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

Weeknum vs Conditional Formatting 5
Issue with conditional formatting 2
Lowest value cell should get highlighted 3
Nested IF Help 3
Average with multiple conditions 4
Conditional Format 1
Conditional Formating Question 5
Conditional Formatting Font Change 1

Back
Top