basically im very new to excell and im trying to create a sales sheet
for my company (tesco) on store performance

and at the moment iv conditioned the cells so that when the LFL target
sales are down the cell goes red eg.
=$C$12<$C$75

and when there equal to or up its a green
which is fine but its currently showing when i have not put the figures
for the future months the cells automatically go green

now i relise that there will be months where the result will be zero so
i cant create another condition that says if zero then condition the
cell white

i need it so that when the LFL fields are blank the cell is white and
not green

can anyone help me pls


--
alphauk101
------------------------------------------------------------------------
alphauk101's Profile: http://www.excelforum.com/member.php...o&userid=33990
View this thread: http://www.excelforum.com/showthread...hreadid=537558