Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting with 4 or more conditions | Excel Worksheet Functions | |||
Conditional Formatting for more than 3 conditions | Excel Worksheet Functions | |||
I have more than 6 conditions when using conditional formatting? | Excel Worksheet Functions | |||
Conditional formatting with more than 3 conditions. | Excel Worksheet Functions | |||
more than 3 conditions in conditional formatting - possible? | Excel Discussion (Misc queries) |