View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CassieB CassieB is offline
external usenet poster
 
Posts: 2
Default 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?