View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
zvkmpw zvkmpw is offline
external usenet poster
 
Posts: 153
Default Conditional Formatting w/ a List/Icons

On Mar 4, 8:13*am, CassieB wrote:
I am trying to allow someone to select "Green", "Yellow" or "Red" from a list
and the cell to display a green/yellow/red icon appropriately. *Or, if
possible, the user could just select the icon (instead of selecting text).. *
Is this possible?


By "icon" do you mean symbols that are available by using this?
Insert Symbol
If so, these can be in a source list for
Data Validation

Conditional formatting can be used to get the right color in the icon
in validated cell.

(I haven't figured out a way to colorize the validation pull-down
list.)