| 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 |
| 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) | |||
Threaded Mode
