Conditional Formatting / Cell Fill Colours
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? |
Conditional Formatting / Cell Fill Colours
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? |
Conditional Formatting / Cell Fill Colours
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? |
All times are GMT +1. The time now is 07:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com