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/