Hi Colin,

Am Sat, 15 Sep 2012 15:54:55 +0100 schrieb Colin Hayes:

=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.

if you have numbers in F17:I17 then try:
=COUNT($F17:$I17)<=2
With text try:
=COUNTA($F17:$I17)<=2



Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2