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