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" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
>
Similar Threads
