We use scorecards quite a bit in my line of work. We often use smilely
face, and sad face to depict satisfactory financial performance. This,
however has to be done by copying the face to the cell over and over.

Can someone advise me on an easy method for setting up a conditional
statement that picks the correct face (object)based on a criterial I
set up. ex. if A1=, $100, "smiley face", "sad face". I don't know any
VBA, but am pretty good with Excel functions.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Format the cell with the WingDings font, and use the following formula:

=IF(A1100,CHAR(74),CHAR(76))

Adjust the font size as desired.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"thorvision" wrote in message
...
We use scorecards quite a bit in my line of work. We often use smilely
face, and sad face to depict satisfactory financial performance. This,
however has to be done by copying the face to the cell over and over.

Can someone advise me on an easy method for setting up a conditional
statement that picks the correct face (object)based on a criterial I
set up. ex. if A1=, $100, "smiley face", "sad face". I don't know any
VBA, but am pretty good with Excel functions.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

WoW, Thanks Chip!! I was so terrified that it would require VBA. This
is the place I will go for all my Excel questions.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/