ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Adding a graphic to a worksheet as a result of If/Then Statemet (https://www.excelbanter.com/excel-worksheet-functions/155876-adding-graphic-worksheet-result-if-then-statemet.html)

drdonpeden

Adding a graphic to a worksheet as a result of If/Then Statemet
 
I want to add a red frown face (as a picture or ClipArt) if a value is less
than x, yellow no-smile-or-frown if greater than x but less than y, and green
smile face if greater than y. Can it be done if I have the three colored
graphics?

Peo Sjoblom

Adding a graphic to a worksheet as a result of If/Then Statemet
 
Only with macros

http://www.mcgimpsey.com/excel/lookuppics.html




--

Regards,

Peo Sjoblom

"drdonpeden" wrote in message
...
I want to add a red frown face (as a picture or ClipArt) if a value is less
than x, yellow no-smile-or-frown if greater than x but less than y, and
green
smile face if greater than y. Can it be done if I have the three colored
graphics?





All times are GMT +1. The time now is 05:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com