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