entering formulas in Excel
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,G13I13),"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,G13I13) -- 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
|