Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
deerhunter98
 
Posts: n/a
Default 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
  #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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you print showing formulas in Excel 2000? Kim Excel Discussion (Misc queries) 3 June 16th 08 09:56 PM
Putting Excel formatting and/or formulas into CSV file Frank D. Nicodem, Jr. Excel Discussion (Misc queries) 1 July 11th 05 10:18 PM
Can Excel recognize when data is entered and apply formulas? cwool4512 Excel Worksheet Functions 2 July 7th 05 07:58 PM
How do I hide formulas in Excel cells? Rita Excel Discussion (Misc queries) 2 February 15th 05 08:55 PM
How Excel & ACCPAC 6.1 calculate formulas???? Bass Mama1 Excel Worksheet Functions 1 February 9th 05 03:25 PM


All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"