Conditional Formatting Using Pictures

[s]

Hi everyone

I am using MS Excel XP and with the basic package. I need to find out is there an easy way to assign a picture such as a smiley face to appear within in a cell when it meets a specific formula condition. Similiar to utilising conditional formatting and shading cells or text; however, a picture would appear instead.

If the cell met another condition that was less favourable a different picture would appear such as and if an even worse condition was met based on the formula another picture such as would appear.

The picture would constantly be able to be changed based on the result of the formula.

* Smilely faces only utilised as an example.

Any ideas of how this may be achieved are greatly appreciated.

Thanks

S

 

[s]

Thanks for the last post, didn't see if before I put my last reply in. Your right the trick is to click right on the border of the comment in order to display all tabs in the format comment window.

I managed to get a picture in the comment. I am a little confused how this will link up to conditional formatting and change as a formula result will change

Utilising a cell for example A1, I need a specific picture to appear if a formula result is between a range of 20% and 30%. If the result returns as 40% - 60% I need a different picture to appear etc.

Not sure how this will work with the comments.

 

[DougStroud]

We can knock it back and forth. First part is to get the picture in there.
Now what is the value you will want to associate w/ this picture?

 

[s]

The formula result will return percentages.

I would like the picture to associate with a of range 40% - 60%. If it is not possible to add a range then 40% can be assigned against the picture

 

[DougStroud]

So 40-60 would be a smiley face, 20-39 would be sad face, something like that?

 

[s]

That's correct

 

[DougStroud]

I think the way to handle this comes back to your original thought, to handle it in code.
Will this be where you have multiple scores on the page down a particular column and the adjacent column will store the appropriate picture?

I will play around w/ this, but the other board members may come up w/ an answer sooner or better solution. But I am done for the night...

For the time being you can do it manually if you need results quicker than I can get them back to you.
Are you comfortable how to do it manually?

 

[s]

You are right in your assumption. The appropriate picture would appear in the adjacent column next to the formula result.

I am not that great with code, and I am more familar with formulas, but am willing to learn.

Thanks for your help tonight. If you do come up with something keep us posted on the forum. I will keep trying until a solution is found.

Thanks again

S.

 

[cpis0002]

hehe, EASY

Hi, There is a much simpler way to do this, all you have to do is add one column, with one basic function.
Email me with your exact needs on chrispisani@gmail.com

 

[DougStroud]

Chris,
Once you solve, will you post to the board?

 

[cpis0002]

Hi, I have solved the problem :P

Email me on chrispisani@gmail.com with the ranges (eg: 0-30 sad) for sad, straight, and smily face, and I will send you all the details. Or if you wish just send me the file and tell me where to put them for you.