I need to specify 6 cell colours according to score

0 = Grey
1 = Red
2 = Yellow
3 = Orange
4 = Brown
5 = Green, for example

However you can only apply 3 conditional formats€¦..has anyone got any ideas
on how to do this?

You would need an add-in or an event macro


http://www.xldynamic.com/source/xld.....Download.html




--


Regards,


Peo Sjoblom

"Coxy19" wrote in message
...
I need to specify 6 cell colours according to score

0 = Grey
1 = Red
2 = Yellow
3 = Orange
4 = Brown
5 = Green, for example

However you can only apply 3 conditional formats...has anyone got any
ideas
on how to do this?

In this particular case, you can change the Font to six colors...

3 by choosing custom format as below
[Green][=5]0;[Yellow][=2]0;[Red]0;
for 5, 2 and 1 (default)
and 3 by conditional formatting..
for 0, 3 and 4

"Coxy19" wrote:

I need to specify 6 cell colours according to score

0 = Grey
1 = Red
2 = Yellow
3 = Orange
4 = Brown
5 = Green, for example

However you can only apply 3 conditional formats€¦..has anyone got any ideas
on how to do this?