Using an IF statement to display an image ...

  • Thread starter Thread starter Mikey C
  • Start date Start date
M

Mikey C

Hi all,

I am using the following IF statement to show the % increase in costs,
only if it is 10% or higher than the running average. If not the cell
stays blank.

=IF(AND(J11>10%,J11<>""),J11,"")

Now .... could anybody tell me how I could change the above formula
(or write some code) so that instead of showing the % increase from
cell J11, it will display a picture of an unhappy face? Sounds a bit
daft but it does capture peoples attention!

I have managed to get something similar using the wingdings font (JKL)
but it's not that great. I already have an emoticon picture I want to
use, in the jpeg format.

Thanks folks - much appreciated :-)


Mike
 
Hi Mike,

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi all,
|
| I am using the following IF statement to show the % increase in costs,
| only if it is 10% or higher than the running average. If not the cell
| stays blank.
|
| =IF(AND(J11>10%,J11<>""),J11,"")
|
| Now .... could anybody tell me how I could change the above formula
| (or write some code) so that instead of showing the % increase from
| cell J11, it will display a picture of an unhappy face? Sounds a bit
| daft but it does capture peoples attention!
|
| I have managed to get something similar using the wingdings font (JKL)
| but it's not that great. I already have an emoticon picture I want to
| use, in the jpeg format.
|
| Thanks folks - much appreciated :-)
|
|
| Mike
|
 
Back
Top