format

[Remoh]

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???

 

[Don Guillett]

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.