Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting using two formula conditions
Basically, I want to apply conditional formatting like so
IF (AD3<"") AND (AE3="") THE so, two linked conditions, is there a way to do this with conditional formatting's "formula is" =AD3<"" works fine, but it's getting two conditions to work that is the problem Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting using two formula conditions
Dan,
Just a minor alteration of what you already have: =And(AD3<"",AE3="") -- steveB (Remove 'NOSPAM' from email address if contacting me direct) "Dan" wrote in message ... Basically, I want to apply conditional formatting like so: IF (AD3<"") AND (AE3="") THEN so, two linked conditions, is there a way to do this with conditional formatting's "formula is"? =AD3<"" works fine, but it's getting two conditions to work that is the problem. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting for 4 conditions | Excel Worksheet Functions | |||
Conditional Formatting - 2 conditions | Excel Discussion (Misc queries) | |||
Conditional Formatting for more than 3 conditions | Excel Worksheet Functions | |||
Conditional Formatting with 4 or more conditions | Excel Worksheet Functions | |||
More than 3 Conditional Formatting Conditions | Excel Worksheet Functions |