lundi 30 octobre 2017

Formatting Pivot table if mutiple adjacent cells are blank

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