bob sacco

Posts: n/a

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Custom Formats	centerNegative	Excel Discussion (Misc queries)	3	October 7th 05 05:01 PM
custom cell number	zander	Excel Worksheet Functions	4	August 23rd 05 02:58 PM
Combobox Number Formats	LostInVBA	Excel Worksheet Functions	0	June 30th 05 09:11 PM
Format Cell (Number Custom)	barryderay	Excel Discussion (Misc queries)	1	April 28th 05 12:18 AM
number formats that allow you to format the appearance of negativ.	jassmon	Charts and Charting in Excel	1	January 15th 05 09:04 AM

All times are GMT +1. The time now is 08:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us