vendredi 31 juillet 2020

Google Sheets - Conditional Formatting - Multiple Check Boxes

Google Sheets Check Boxes Conditional Formating Multiple Boxes.

CLICK ON THE TITLE TO SEE AN IMAGE OF THE SPREADSHEET

I am trying to make conditional formatting in google sheets so that if one box is checked, the row highlights orange; if the second checkbox is marked, the row is highlighted red; and if both checkmarks are marked, the row highlights green. I think I can do this if I create a formula: =IF([$Z4]$1 = 1, "A") + IF([$AA4]$2 = 1, "B") +IF([$z4:$AA4]$3 = 1, "C") and then set the conditional formating based on the letter returned by the formal. Some help would be appreciated




Aucun commentaire:

Enregistrer un commentaire