View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kent McPherson[_2_] Kent McPherson[_2_] is offline
external usenet poster
 
Posts: 27
Default 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?