blondiefunk69
blondiefunk69

Reputation: 21

How to highlight entire rows if, value on a cell below is TRUE?

I want to highlight say row 1 if cell C2 contains the value TRUE, then hight row 2 if C3 contains the value True and so on. How can I do this?

Upvotes: 0

Views: 258

Answers (1)

BigBen
BigBen

Reputation: 49998

Use a rule with the formula:

=$C2

and apply it to all the cells in the worksheet.

enter image description here

Upvotes: 3

Related Questions