Multiple conditional formatting rules across multiple ranges?
72,666
You should use CONDITIONAL FORMATTING:
1) Select all cells in the sheet (by pressing on the top left corner):
2) With selected range go to "Conditional Formatting -> New Rule.."
3) Select "Use formula..." rule type, enter formula =AND($E1>30,$L1>100)
. Choose desired format and press "OK"
RESULT:
Author by
Admin
Updated on May 29, 2020Comments
-
Admin almost 4 years
I need to do the following. Highlight a row if cell E contains a number greater than 30 AND cell L contains a number greater than 100. This rule needs to be applied to all rows. Can you help please?