CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulags-conditional-formatting
Simon Wilhelm
Simon Wilhelm

Reputation: 11

Conditional formatting depending on checkbox

What I want to happen:
Depending on whether a tick box is clicked or not the corresponding cell on the same row should be colored (box unchecked) - so it would look like this:

enter image description here

My best guess was doing the following:
enter image description here

Upvotes: 1

Views: 461

Answers (1)

player0
player0

Reputation: 1

to color a whole row you need to freeze the column with $

=$G2=FALSE

applied to range A2:Z

Upvotes: 1

Related Questions