I am trying to create a conditional formatting rule that if 5 adjacent cells are blank in the same row in a pivot table that it will highlight all 5 cells.
I already have blank cells highlighted but I can't figure out the rule for multiple. For example if A1 has a value of 1 and A2-A8 are blank but A9 has a value of 2 how do I highlight A2-A8 so that it stands out from single blank cells.
Aucun commentaire:
Enregistrer un commentaire