On Saturday, September 15, 2012 8:25:05 PM UTC+5:30, Colin Hayes wrote:
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

Hi,
There is complete Video Tutorial Series on Conditional formatting that ihave created hope that would help you. http://www.youtube.com/playlist?list=PLA6FD047BBA06B5A8