Forum Discussion
Conditional formatting based on a checkbox
Good afternoon. I wonder if someone can help me please :-) I have a spreadsheet that has rows of client data, what I am trying to achieve is when I click the checkbox it turns the row green...
In my online / web interface here is my Conditional Formatting (add new rule) window:
notice the Fx all the way to the right, that is the use a custom formula.
then you just need to use a formula like
=$A1
where the $A needs to be the column where the checkbox is, and
the 1 needs to match the first row in the "Apply to:" range