Home |
Search |
Today's Posts |
#1
|
|||
|
|||
color coding custom number formats
I'm attempting to color code a series of numbers using the custom number
format in the FORMAT MENU. I need to color code four numbers (or ranges of numbers) 10%, 50%, 90% and 100% Currently I have: [Yellow][=0.01] 0%;[Green][=0.05]0%;[Blue][=0.09];[Red][=1]0%;@ But I can't get it to work. Any ideas why? |
#2
|
|||
|
|||
J.E. McGimpsey shows how to get up to 6 different colors using a combination of
custom formats and conditional formatting at: bob sacco wrote: I'm attempting to color code a series of numbers using the custom number format in the FORMAT MENU. I need to color code four numbers (or ranges of numbers) 10%, 50%, 90% and 100% Currently I have: [Yellow][=0.01] 0%;[Green][=0.05]0%;[Blue][=0.09];[Red][=1]0%;@ But I can't get it to work. Any ideas why? -- Dave Peterson |
#3
|
|||
|
|||
oops. I hit send too fast.
J.E. McGimpsey shows how to get up to 6 different colors using a combination of custom formats and conditional formatting at: http://mcgimpsey.com/excel/conditional6.html And watch out... 10% = .10 50% = .50 90% = .90 100% = 1 bob sacco wrote: I'm attempting to color code a series of numbers using the custom number format in the FORMAT MENU. I need to color code four numbers (or ranges of numbers) 10%, 50%, 90% and 100% Currently I have: [Yellow][=0.01] 0%;[Green][=0.05]0%;[Blue][=0.09];[Red][=1]0%;@ But I can't get it to work. Any ideas why? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Formats | Excel Discussion (Misc queries) | |||
custom cell number | Excel Worksheet Functions | |||
Combobox Number Formats | Excel Worksheet Functions | |||
Format Cell (Number Custom) | Excel Discussion (Misc queries) | |||
number formats that allow you to format the appearance of negativ. | Charts and Charting in Excel |