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