Hello Ronald_peterson,
Yes you can play the sound of your choosing based on a cell's value changing. As for the color change that is isn't so simple, and would require some very advanced programming.
First add a Standard VBA Module to your Workbook. Copy the macro code below and paste it into the module. Next follow the directions to insert the conditions checking into the Worksheet_Change event. You can add the sound file names you want to use in the macro. The macro plays a sound when any cell's value equals 100.
Sound Macro Code:
Condition Checking Code:
To install the Worksheet_Change() code:
1) Copy the code using CTRL+C.
2) Right Click on the Worksheet tab of the worksheet the macro will run on.
3) Select "View Code" from the pop up menu.
4) Paste the macro event code using CTRL+V.
5) Save the code using CTRL+S.
Sincerely,
Leith Ross
Bookmarks