Audible and pop up notification on cell color change

Title sums it up pretty well. I have a file where one cell changes to red on error and I am hoping to have it generate a popup and sound when that happens. Not great with VBA but I found some sites where I created a "beepnow" script and a macro but I was only able to get it working on a formula and not a color change. Attached is a sample file, it is pretty simple. C10-19 are the source or original numbers, D10-19 is where you would validate against the C numbers. My team specifically uses this for serial numbers where we are validating from a list and we scan into the D columns. I am hoping I can get an error message to popup anytime D6 turns red to warn the person they scanned the wrong thing. The sample has some of the C columns populated and you will see that D13 does not match against any of the numbers in the C columns so you get a no-match and D6 changes to red.

If there is already some information here in the forum for this feel free to redirect me, I was unable to find much on the subject and most of it is older.

I am currently running O365.

Thanks!!!

PS - If anyone wants bragging rights, I would love it in the media validation columns B and E displayed nothing if the cells they relate to are blank. In the example file D14-D19 have no data but E14-E19 say no match until there is one.