Conditional Formatting - 2 conditions
 

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 a
(Note that D1 holds a date).
D1 Today()
E1 < "YES"
I tried:
Formula is:
=If(And(D1Today(), E1<"YES"))
Excel adds quotes as:
="If(And(D1Today(), E1<""YES""))"
But the formatting is not applied.
What am I doing wrong? Thanks for your time. Otto

Conditional Formatting - 2 conditions
 

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(D1TODAY(), E1<"YES")
--
David Biddulph

"Otto Moehrbach" wrote in message
...
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
a (Note that D1 holds a date).
D1 Today()
E1 < "YES"
I tried:
Formula is:
=If(And(D1Today(), E1<"YES"))
Excel adds quotes as:
="If(And(D1Today(), E1<""YES""))"
But the formatting is not applied.
What am I doing wrong? Thanks for your time. Otto

Conditional Formatting - 2 conditions
 

Try:

=AND(D1TODAY(), E1<"YES")

Regards

Trevor


"Otto Moehrbach" wrote in message
...
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
a (Note that D1 holds a date).
D1 Today()
E1 < "YES"
I tried:
Formula is:
=If(And(D1Today(), E1<"YES"))
Excel adds quotes as:
="If(And(D1Today(), E1<""YES""))"
But the formatting is not applied.
What am I doing wrong? Thanks for your time. Otto

Conditional Formatting - 2 conditions
 

David, Trevor
Thanks for your help. Otto
"Trevor Shuttleworth" wrote in message
...
Try:

=AND(D1TODAY(), E1<"YES")

Regards

Trevor


"Otto Moehrbach" wrote in message
...
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
a (Note that D1 holds a date).
D1 Today()
E1 < "YES"
I tried:
Formula is:
=If(And(D1Today(), E1<"YES"))
Excel adds quotes as:
="If(And(D1Today(), E1<""YES""))"
But the formatting is not applied.
What am I doing wrong? Thanks for your time. Otto