Conditional Statement-w/Objects

  • Thread starter Thread starter thorvision
  • Start date Start date
T

thorvision

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.
 
Format the cell with the WingDings font, and use the following formula:

=IF(A1>100,CHAR(74),CHAR(76))

Adjust the font size as desired.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
WoW, Thanks Chip!! I was so terrified that it would require VBA. This
is the place I will go for all my Excel questions.
 
Back
Top