Alowing a cell to change a picture

[whatzzup]

Good morning, i have a situation where i have a conditional format to do a
traffic light, but i want to use the same data to manipulate arrows in the
adjacent cell, this will point up when red, right when green and left when
Amber.

Can this be done? How do i do that if it is possible?

 

[Gary''s Student]

You can use the Wingdings 3 font to make arrows. Here is a very simply
example:

=IF(A1>A2,"#",IF(A1<A2,"$",2))
and format to Wingdings 3

just use the same test in the formula as you use in the conditional format.