cell conditioning

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alphauk101 - 30 Apr 2006 09:48 GMT

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

and at the moment iv conditioned the cells so that when the LFL targe
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 figure
for the future months the cells automatically go green

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

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

can anyone help me pl

Reply to this Message

Bob Phillips - 30 Apr 2006 11:32 GMT

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

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> basically im very new to excell and im trying to create a sales sheet
> for my company (tesco) on store performance
[quoted text clipped - 15 lines]
>
> can anyone help me pls

Reply to this Message