Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop down list with shapes
I'd like to create a drop down list of 3 items, a red
diamond, green circle,& a yellow triangle that I can put into many cells for a stop light chart. I 've tried using the data validation with the ASCII codes but it didn't work Any suggestions or help would be appreciated Thanks Neil |
#2
|
|||
|
|||
You can't format the items in a data validation list, so you won't be
able to show the colours, or a different font. Perhaps you could show Low, Medium, High as the list items, and show the appropriate symbol in an adjacent cell. Neil wrote: I'd like to create a drop down list of 3 items, a red diamond, green circle,& a yellow triangle that I can put into many cells for a stop light chart. I 've tried using the data validation with the ASCII codes but it didn't work Any suggestions or help would be appreciated Thanks Neil -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
I solved it by using the data validation list and
conditional format (to change the colors), all shapes have to be in the same font l=circle n=square t= diamond in windings font I had to change the triangle into a square to make it work Thanks, Neil -----Original Message----- You can't format the items in a data validation list, so you won't be able to show the colours, or a different font. Perhaps you could show Low, Medium, High as the list items, and show the appropriate symbol in an adjacent cell. Neil wrote: I'd like to create a drop down list of 3 items, a red diamond, green circle,& a yellow triangle that I can put into many cells for a stop light chart. I 've tried using the data validation with the ASCII codes but it didn't work Any suggestions or help would be appreciated Thanks Neil -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select drop down list 1 value will change the value in dr... | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |