cell conditioning

[alphauk101]

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

[Bob Phillips]

I 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($C12<>"",$C12<$C75)

but adjust to what you actually know about those cells

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"alphauk101" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>