Conditional Formatting Formula Help

I am trying to do conditional formatting where the color of the row changes based on the number of check boxes checked. There are 3 check boxes and they can be checked in any order. So for example one box is checked the row turns yellow, any two of the three boxes are checked the row turns blue and then when all three boxes are checked it turns green.

Any help would be appreciated.

Hello @Jennifer_Biggs ,

Just count the checkboxes (marked = 1, unmarked = 0) and apply a conditional format based on the total.
Check a sample in this doc, page ‘Counting checkboxes’:



That was perfect. Thank you so much!!