| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically insert a graphic?
I have a spreadsheet where I want to create a traffic light view of the
data. For example: Value 1-3 = red circle Value 4-6 = yellow circle Value 7-10 = green circle The formula I'm working with looks like this: =IF(Sheet1!B2<4,red,IF(Sheet1!B2<7,yellow,green)) The red, yellow, and green items need to pull graphic symbols which is where I'm struggling. How can I do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert a graphic into header of spreadsheet | Excel Discussion (Misc queries) | |||
| How do I insert a graphic into header of spreadsheet | Excel Discussion (Misc queries) | |||
| How do I insert a graphic into header of spreadsheet | Excel Discussion (Misc queries) | |||
| How do I programmatically get access to a picture or graphic? | Excel Programming | |||
| Insert a graphic in a cell | Excel Discussion (Misc queries) | |||
![Kent McPherson[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
