Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional nested formatting for cell color changes
I don't completely understand the rules when combining "AND" and "OR"
together in various ways to test various conditions to turn a cell red or green depending upon the results of the "AND(OR" or "OR(AND" or multiple nested AND(OR tests. I think I must have my ( ) in the wrong places. How do I tell Excel which tests I want in the first nested "AND(OR" statement, and separate the first test from the 2nd "AND(OR", etc. Does it require (( ...)), ie double parenthesis is certain places to group each test separately? Where can I go to find some reading material on this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting to color rowsbased on cell value | Excel Discussion (Misc queries) | |||
Is conditional formatting or formula possible by cell color? | Excel Worksheet Functions | |||
How can I change cell color using conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting and Cell Color | Excel Worksheet Functions | |||
Cell color change without using conditional formatting | Excel Discussion (Misc queries) |