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. I have researched it and all the info look different to the conditional formatting I can see, I am using Excel 365 web based excel I don't see the the option 'Use a formula to determine which cells to format.'
I see apply to: and Format Cell where the formula is true can someone please help
Thanks Joel
1 Reply
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
