You can also use a conditional format for your button.
Thanks for replying. I know that you can use conditional formatting, but im not sure exactly what formulas i should be using in order to set up the format i'm looking for. I did set it so that if a field was filled, it would change the color of the button, but that made it so that there was no way to tell if all of the boxes had been filled or just one.
This is a comparing-lists problem.
What is the list of approval emails?
What is the list of received emails?
Do all the values in the approval list occur at least once in the received email list.
You will need to learn about the FilterValues function.