Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you print showing formulas in Excel 2000? | Excel Discussion (Misc queries) | |||
Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
Can Excel recognize when data is entered and apply formulas? | Excel Worksheet Functions | |||
How do I hide formulas in Excel cells? | Excel Discussion (Misc queries) | |||
How Excel & ACCPAC 6.1 calculate formulas???? | Excel Worksheet Functions |