Hi

In conditional formatting I use this formula :

=COUNTIF($F17:$I17,0)=2

formatted to apply the colour white to the font to effectively blank out
all cells between $F17:$I17 if any are empty.

If any of the cells in the range are empty , then all content is
coloured white and 'disappears' on the screen. If I make an entry then
the content of the cells appears black and becomes visible.

Curiously though if I remove the entry and make the cell blank again ,
they don't follow the formatting and become white again. They stay black
, even though the range now has the empty cell which should trigger the
condition formatting.

Can anyone suggest a formula which would correct this?


Grateful for any help.



Best Wishes