I've never fooled with drop-down lists in Excel - the occasional command
button, is all - but presumably you know how to do that part. You're just
asking asking how to ....

Come to think of it, you haven't asked anything yet. What have you tried,
and what isn't working? And HOW isn't it working?

--- "Anders" wrote:
...you're right with a+b. I want the user to click
the destination cell, see a dropdown list containing
5 (alphanumeric) values, and select one (no other
values can be entered into the cell). Once selected,
the font/fill will change based on the item selected.