This works perfectly! Thank you!
One thing I didn't consider is that I don't want the cells to stay yellow indefinitely. I decided to add a button with a macro to clear the highlighting.
Would there be a line I could add to the code you supplied, to remove any highlighting that is already there if the user runs the code again without pushing the button I created to remove it?
Bookmarks