Format cell color based on multiple variables
 

I am creating a spreadsheet that imports data from another sheet. A
group of cells are to be assigned a color based on thier imported data,
however, the color assignments need to be able to be defined and changed
from a "key" which I want to locate on the page itself. see attached for
example.

Any thoughts on a good way to go about doing this?
I have been playing with formulas all day. I can use conditional
formatting but that only defines the color based on the number in the
cell and does not allow me to change the numerical color range from the
page itself.

Thoughts?


--
chuzie
------------------------------------------------------------------------
chuzie's Profile: http://www.excelforum.com/member.php...o&userid=31053
View this thread: http://www.excelforum.com/showthread...hreadid=507254