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?