entering formulas in Excel

[Guest]

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

 

[Guest]

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