Conditional Formatting question

Originally Posted by Nymphadora

I have been playing with the new Office 2007 (I like it a lot), and one of the features is the Icon Sets for conditional formatting. While this is ok in Excel 2007, I lose this formatting when I have to work on my work computer running Office 2000.
My main question is: Is there a way to have conditional formatting insert an image?
For example:
In cell A1 I have the formula "=IF(A1 > 1, 1, -1)"
I would like it if the value is 1 then an image of a green check mark shows, else if it is -1 then an image of a red X.
RedX.jpg
GreenCheck.jpg
These images woul dbe stored in the same directory as the Excel file I am wanting to use them in.

Thanks for any help you can offer.
-Nym

Not by CF, but I believe that I saw a method to add a picture inside a comment box, and for that picture to be adjusted on the changing of a cell value (Worksheet_Change), perhaps this, together with the green and red CF setting would suit your needs until 2007 were more available to you.

---