Conditional Colour Formatting

  • Thread starter Thread starter Lesley
  • Start date Start date
L

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
 
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
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top