I want to put a color in a a column of cells from a drop down menu that pops
up when I click a cell to indicate risk-green for safe, blue, yellow orange
to red for riskiest. Then I want to average the column to give me a result
color. Anyone done something like that before?

thx ;=)