Hello,

Just wondered if someone could help me with a problem I've
got with an excel chart.

I have a column chart which is linked to a lookup table
which shows amounts spent by month. If the amount spent is
over 50 I would like the column to be red and if it is
less than 50 I would like the column to be green.

Is there anyway of automatically updating the colour of
the column according to its value? as the graph amounts
will change each time I change the lookup value.

I hope this makes sense!

Thanks

Lesley