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" <(E-Mail Removed)> wrote in message
news:811A27F8-85D7-4A41-A7C7-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:AAF25071-A9CF-4984-AE36-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in
>> message
>> news:811A27F8-85D7-4A41-A7C7-(E-Mail Removed)...
>> > 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.
>> >>
>> >> .
>> >>
>>