cell conditioning

  • Thread starter Thread starter alphauk101
  • Start date Start date
A

alphauk101

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
 
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)
 
Back
Top