CODEWITHSUNDEEP
excelexcel-formulaconditional-formatting
Louise Brain
Louise Brain

Reputation: 131

Multiple conditional formatting rules across multiple ranges?

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?

Upvotes: 7

Views: 76542

Answers (1)

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35863

You should use CONDITIONAL FORMATTING:

1) Select all cells in the sheet (by pressing on the top left corner):

enter image description here

2) With selected range go to "Conditional Formatting -> New Rule.."

enter image description here

3) Select "Use formula..." rule type, enter formula =AND($E1>30,$L1>100). Choose desired format and press "OK"

enter image description here

RESULT:

enter image description here

Upvotes: 7

Related Questions