Conditional Formatting w/ a List/Icons

  • Thread starter Thread starter CassieB
  • Start date Start date
C

CassieB

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?
 
Use Data Validation for the list. Type in Red, Yellow, Green as the list.

This give the user the list to select from.

Use Conditional Formatting for the fill part. Set three conditions, If Cell
Value-"Green" (select a green fill), etc..
 
I am able to use the fill to format the cell, but was wanting to use the
icons - anyway to do that?
 
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?
Click to expand...

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.)
 
Back
Top