software

I am new to this site, but not to Excel.

Can you put custom animations in cells?

e.g. - I am using the following formula in my worksheet:
=IF(AND(G13gt;=H13,G13lt;=I13),quot;WITHIN SPECquot;,quot;OUT OF SPECquot;)

Upon the event that I have the false statement, I would like something to
happen to kinda grab the users attention. Something like a Sound Event or
Popup Window. Is there anyway to do this?

Thanks,

BJ Mays

Hi,

You could use Conditional Formatting to show G13 as well as the cell
containingg the formula, in maybe a different color(say red), font (say
italic and bold), etc, when the formula returns quot;OUT OF SPECquot;.

For that, first modify your formula a little bit as follows:

=IF(OR(G13lt;H13,G13gt;I13),quot;OUT OF SPECquot;,quot;WITHIN SPECquot;)

Then for the Conditional Formatting,

Click on the cell containing the above formula --gt; quot;Formatquot; --gt; quot;Conditional
Formattingquot; --gt; click on quot;Cell Value Isquot; and select quot;Formula Isquot; --gt; in the
formula bar =OR(G13lt;H13,G13gt;I13) --gt; click on the quot;Formatquot; button by the
side and format the font, border, and pattern as you wish --gt; quot;OKquot; --gt; quot;OKquot;
Now, click on G13 and repeat the above procedure.

Regards,
B. R. Ramachandran

quot;deerhunter98quot; wrote:

gt; I am new to this site, but not to Excel.
gt;
gt; Can you put custom animations in cells?
gt;
gt; e.g. - I am using the following formula in my worksheet:
gt; =IF(AND(G13gt;=H13,G13lt;=I13),quot;WITHIN SPECquot;,quot;OUT OF SPECquot;)
gt;
gt; Upon the event that I have the false statement, I would like something to
gt; happen to kinda grab the users attention. Something like a Sound Event or
gt; Popup Window. Is there anyway to do this?
gt;
gt; Thanks,
gt;
gt; BJ Mays