This is almost what I'm looking for. However, I won't be able to use this method because I have 80 different choice possiblities in the drop-down (colors). This would mean I'd have to have 80 boxes on the form, each one with a different color in the formula. I'm hoping to get a formula that would fill in the ...