How do I make a sound as a result of an "if" statement in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wish to alert a data inputer if the answer of a calculation falls outside a
certain range, eg>300 <20. The data inputer does not touch type. I hore that
I could use an "if" statemnt to achieve the required result.
 
A formula can't create a sound. You could use programming to create a
sound if the cell value is outside a specified range when the sheet
calculates.

Or, you could use conditional formatting to colour the cell if its value
is outside the specified range. There are instructions in Excel's Help,
and here:

http://www.contextures.com/xlCondFormat01.html
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I perform calculation within IF statement? 3
how do you highlight the result of an IF statement 5
How can I add up multiple IF results. 3
Return result of IF logical test in a different cell 1
Logical test in IF statement returning incorrect result 3
how do I referance a data valuation cell from another worksheet 2
Comparing a cell result with a pre-defined value range 1
sum of multiple IF statements 9

Back
Top