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
|
|||
|
|||
Couple of reasons:
- Custom formats can only have 3 numeric format fields, not 4. - your [Blue] format doesn't have a numeric format. - if you have numeric ranges in your custom format, the ranges must encompass all numbers. In your format string, the format of any value <0.01 is undefined. - the syntax for greater than or equal to is "=" rather than "=" See http://www.mcgimpsey.com/excel/conditional6.html In article , 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? |
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 |