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