Conditional Colour Formatting

[Lesley]

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

 

[Andy Pope]

Hi Lesley,

Have a look at Jon's example.
(http://peltiertech.com/Excel/Charts/ConditionalChart1.html)

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

--

Cheers
Andy

http://www.andypope.info