Data ValidationAllowList for the dropdowns.

http://www.contextures.on.ca/xlDataVal01.html

FormatCondtional Formatting for the colors.

http://www.contextures.on.ca/xlCondFormat01.html


Gord Dibben MS Excel MVP

On Mon, 17 Dec 2007 09:12:00 -0800, jpas1954
wrote:

Someone sent me a spreadsheet that has drop-down buttons embedded. When you
click on them, you can change not only wording but also the color of the
cell. (Green/yellow/red). I'd like to do this as well but haven't a clue. How
difficult is this to do and where would you set this sort of thing up?