In Google Sheets, I would like each row to turn green, once two of the checkboxes (in Columns F and G) are checked for that row.
I have tried using conditional formatting with the following formulas applied to range A2:I145
:
=IF($F2=TRUE,1)=AND($G2=TRUE,1) /* This colors the row when cells are unchecked */
=IF($F2:$G2=TRUE) /* This does not color the row at all */
I know that if it was only based on one checkbox, it could be accomplished with =$F2=TRUE
. There is documentation on this here, but they don't give an example with requirement of two checkboxes.
Is there a simple function that can perform this task?
Aucun commentaire:
Enregistrer un commentaire