software

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$12lt;$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: www.excelforum.com/member.php...oamp;userid=33990
View this thread: www.excelforum.com/showthread...hreadid=537558I would have thought that with their profits, Tesco could buy a solution!

I am not clear which cell is the LFL target and actual, but you should just
add a test to cater for the actual being blank as well. Also, I don't know
why your formulae are fully absolute, as this does not make it easy to
extend for more stores.

So, it would be something like

=AND($C12lt;gt;quot;quot;,$C12lt;$C75)

but adjust to what you actually know about those cells

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;alphauk101quot; gt; wrote
in message ...
gt;
gt; basically im very new to excell and im trying to create a sales sheet
gt; for my company (tesco) on store performance
gt;
gt; and at the moment iv conditioned the cells so that when the LFL target
gt; sales are down the cell goes red eg.
gt; =$C$12lt;$C$75
gt;
gt; and when there equal to or up its a green
gt; which is fine but its currently showing when i have not put the figures
gt; for the future months the cells automatically go green
gt;
gt; now i relise that there will be months where the result will be zero so
gt; i cant create another condition that says if zero then condition the
gt; cell white
gt;
gt; i need it so that when the LFL fields are blank the cell is white and
gt; not green
gt;
gt; can anyone help me pls
gt;
gt;
gt; --
gt; alphauk101
gt; ------------------------------------------------------------------------
gt; alphauk101's Profile:
www.excelforum.com/member.php...oamp;userid=33990
gt; View this thread: www.excelforum.com/showthread...hreadid=537558
gt;