I did a search to see if this was asked before and didn't find anything. What I want to do is reference a cell, if the value is 1 display a graphic image of a GREEN light, if 2 display image of YELLOW light and if 3 then display image of RED light.
I know I can use conditional formatting to set a cell's color based on value, but I want to use a more eye appealing graphic image (.jpg) to be displayed.
Any suggestions as to how this is best accomplished?
Thanks!
I know I can use conditional formatting to set a cell's color based on value, but I want to use a more eye appealing graphic image (.jpg) to be displayed.
Any suggestions as to how this is best accomplished?
Thanks!