entering formulas in Excel

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(G13>=H13,G13<=I13),"WITHIN SPEC","OUT OF SPEC")

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 "OUT OF SPEC".

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

=IF(OR(G13<H13,G13>I13),"OUT OF SPEC","WITHIN SPEC")

Then for the Conditional Formatting,

Click on the cell containing the above formula --> "Format" --> "Conditional
Formatting" --> click on "Cell Value Is" and select "Formula Is" --> in the
formula bar =OR(G13<H13,G13>I13) --> click on the "Format" button by the
side and format the font, border, and pattern as you wish --> "OK" --> "OK"
Now, click on G13 and repeat the above procedure.

Regards,
B. R. Ramachandran

"deerhunter98" wrote:

> 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(G13>=H13,G13<=I13),"WITHIN SPEC","OUT OF SPEC")
>
> 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