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.
.
|