Can easily be accomplished using a combination of "Conditional Formatting"
and "Data Validation" in the same cell.

Check out the Help files.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Lynn. Rickards" wrote in message
ups.com...
I'm looking to construct a dropdown with values, say, 'hot', 'warm',
'cool'
where each of those options have individually colored background. When
selected, the color in the cell or widget background should stick'.

Can this be done please?

Thanks - Lynn.