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