Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill autoshape color with ref cell conditional formatting | Excel Worksheet Functions | |||
how do i get more than 3 colours in conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting with Colours / Colors | Excel Worksheet Functions | |||
Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
How do I set up conditional cell fill colours in Excel? | Excel Worksheet Functions |