I will give an example:
I have checkboxes in
This is a checklist, I want to change the background color to green for
B3:G3 boxes are checked.
Can someone please tell me how to do that?
Go to the menu: Format -> Conditional formatting.
Custom formula is
=AND($B3=TRUE, $C3=TRUE, $D3=TRUE, $E3=TRUE, $F3=TRUE, $G3=TRUE)