IF formula to change cell color if checkbox is or isn't checked

danatheclalouise

I'm looking to create a formula to change an individual's cell color if the checkbox for the cell is checked. I've tried different formulas but can't seem to get it right.

All columns in the specific sheet include checkboxes. If the checkbox is checked, I want the cell background to be green. If the box is unchecked, I want the cell background to be gray. Can anyone help me understand which formula to use?

Thank you!

Todd M Keller

I believe you're looking to create a 'conditional formatting' rule.

https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting

Todd M Keller

I believe you're looking to create a 'conditional formatting' rule.

https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting

danatheclalouise

Yes, that worked, thank you so much!

I thought I would have to type out a formula but this was so much easier!