Drop-down buttons

[jpas1954]

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?

 

[T. Valko]

Are you thinking about a drop down list?

See if this is what you had in mind:

 

[Gord Dibben]

Data Validation>Allow>List for the dropdowns.

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

Format>Condtional Formatting for the colors.

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


Gord Dibben MS Excel MVP