View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Russell Dawson[_2_] Russell Dawson[_2_] is offline
external usenet poster
 
Posts: 181
Default Clip art in Excel 2007

If you want check to appear when text in cell a1=balance and x when text
reads no balance try this in B1

=IF(A1="balance","ü","û")

You need to ensure that B1 font is Wingdings

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"CAM" wrote:

Hello,

I have two clip arts in my Excel 2007 one is check mark and the another is
a "X" in a particular cell I would display the text "Balance", which I
like to have the check mark clip art appear. If the same cell has the text
"Not Balance" then I want to show the clip art with the "X" and the clip art
with the check mark disappear. Is this possible? I would appreciate any
tips. Thank you in advance.

.