Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting Icons | Excel Worksheet Functions | |||
Conditional Formatting - Looking for Red/Yellow/Green Icons, w/ wo | Excel Worksheet Functions | |||
Conditional formating icons | Excel Discussion (Misc queries) | |||
conditional formatting from a list | Excel Worksheet Functions | |||
Conditional Formatting Icons | Excel Discussion (Misc queries) |