vendredi 29 mai 2020

Google Sheets - Change row color once multiple boxes are checked

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