Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format
EXCEL is there a way to color code the cell contents/background based on
value of cell so that color can run the entire spectrum from say a value of 0 as white to yellow to orange to red to purple to green to blue to brown to black which would have value of 1. Conditionally formatting only gives several discrete options. Ideally, a function such as COLOR(n) where n is value between 0 to 1 and representing entire rainbow of color spectrum??? -- HRR |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "Remoh" wrote in message ... EXCEL is there a way to color code the cell contents/background based on value of cell so that color can run the entire spectrum from say a value of 0 as white to yellow to orange to red to purple to green to blue to brown to black which would have value of 1. Conditionally formatting only gives several discrete options. Ideally, a function such as COLOR(n) where n is value between 0 to 1 and representing entire rainbow of color spectrum??? -- HRR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel |