Display msgbox once if any cell in range is a specific color

Hi All,

I am trying working on a spreadsheet that has users enter data into cells that are color coded. For example, if a cell has a yellow background, it needs to be populated. If it's not populated, the background color needs to be changed to a red and a msgbox needs to pop up and tell them "hey, you didn't fill out all required fields!"

I feel like I have the code figured out to define the range of the cells that need to be validated (with the help of taking examples I've found online and tweaking them). I also feel like I've figured out how to change the background colors of empty yellow cells to red. I'm just stuck on how to have the range searched for any red background cells and create a msgbox ONCE to let the user know there is a field or more than one field that needs to be filled out). A few weeks ago, I had figured out a way to have it display a message box for EVERY cell, but that is totally cumbersome if there are 100 cells with a red background. Here's the code I'm working with so far:

Please Login or Register  to view this content.

Looks close, a few tips for you to try and fix it yourself, although I will do it for you if you're having problems.

Declare a Boolean variable and set it to true when you change a cell to red.

Remove the 'exit for' line.

Display message box if the Boolean variable is true. This needs to be after 'next cell' or you will get it more than once.

Thanks, Jason! That did the trick. A good way to end a Friday