mardi 29 octobre 2019

Highlighting a whole row if number of blank cells in the row = a certain number

I'm trying to highlight a row if the number of blank cells between say, C1 and E1 = 3

and then copy this down for every row.

I've tried using

=IF(COUNTBLANK($C1:$E1)=3)

But it's not working, can anybody help? Many thanks.

Aucun commentaire:

Enregistrer un commentaire