Conditional Formatting w/ a List/Icons
 

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?

Conditional Formatting w/ a List/Icons
 

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..
--
If this helps, please remember to click yes.


"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?

Conditional Formatting w/ a List/Icons
 

I am able to use the fill to format the cell, but was wanting to use the
icons - anyway to do that?

"Paul C" wrote:

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..
--
If this helps, please remember to click yes.


"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?

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