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?

Are you thinking about a drop down list?

See if this is what you had in mind:

http://youtube.com/watch?v=t2OsWJijrOM

--
Biff
Microsoft Excel MVP


"jpas1954" wrote in message
...
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?

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?