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.

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.

.

Hey Russell,

Thanks for the tip, hats off . This is what I needed. Thank you for your
help.


"Russell Dawson" wrote in message
...
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.

.

My pleasure.

Please hit the "Yes" box. I need the scores !!

Cheers

Russell
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"CAM" wrote:

Hey Russell,

Thanks for the tip, hats off . This is what I needed. Thank you for your
help.


"Russell Dawson" wrote in message
...
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.

.

Sure! I rated as Useful. I hope that is what I needed to do. Else let me
know. Thanks again.


"Russell Dawson" wrote in message
...
My pleasure.

Please hit the "Yes" box. I need the scores !!

Cheers

Russell
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"CAM" wrote:

Hey Russell,

Thanks for the tip, hats off . This is what I needed. Thank you for your
help.


"Russell Dawson" wrote in
message
...
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.

.