| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting
What's wrong with this Conditional Formula?
=AND(OR(AI16<"No Response",AI16<"Get Back",AI16<"Returning",AI16<"Returned")),(OR(AND (AQ16="Ph",AR160,AP160,AW16="",AX16=""),(AND(AQ1 6="Ph",AR160,AP160,AW16="")))). My goal is to evaluate the first OR condition and if True then evaluate either of the AND conditions as follows: AND(OR(if true), then calculate (OR(AND(____),AND(____)) IF any of the first OR conditions are True, then perform the calculations in either of the AND conditions, whichever one is True. I believe my syntax is incorrect as I get error messages when pressing OK. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
