View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
B. R.Ramachandran
 
Posts: n/a
Default 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