help required

[BDCC]

I have to do a report which works out percentages and would like it to
automatically change the colour of the text depending on the figure. For
90% and above I would like it in green, between 75% and 89.99% amber and
everything else red, is this possible and how can it be done?

Additionally these are then displayed on a line chart, is there a way of
colouring the lines in the same format as above, ie if the previous score is
76% and goes to 91% as it goes through the 90% it turns from amber to green,
or put coloured bands in the plot area. Any ideas??

thanks

 

[Frank Kabel]

Hi BDCC

I have to do a report which works out percentages and would like it to
automatically change the colour of the text depending on the figure.
For 90% and above I would like it in green, between 75% and 89.99%
amber and everything else red, is this possible and how can it be
done?

For this you can use conditional formating (goto 'Format - conditional
format') Though you can only choose 3 conditions (or counting the
default format 4 conditions).
For more infos see
http://www.cpearson.com/excel/cformatting.htm

Additionally these are then displayed on a line chart, is there a way
of colouring the lines in the same format as above, ie if the
previous score is 76% and goes to 91% as it goes through the 90% it
turns from amber to green, or put coloured bands in the plot area.
Any ideas??

have a look at
http://www.tushar-mehta.com/excel/newsgroups/shaded_tqm/index.html
http://www.tushar-mehta.com/excel/newsgroups/shaded_band_xy_chart/index
..html

Frank

 

[JE McGimpsey]

You can actually get 6 font colors using a combination of conditional
and custom formatting. See

Getting 6 conditional font colors without macros
http://www.mcgimpsey.com/excel/conditional6.html

 

[Frank Kabel]

Hi
nice trick !!

Frank