Change color of macro button based on cell value

You cannot change the color of a Forms button. For that you do need an ActiveX button.
And to have the color changed automatically you do need a little piece of vba. The change event of the sheet could be used for that.
Also when using an ActiveX button your macro would need to be moved the the button click_event.

Though this may seem intimidating to you, all that really isn't rocket science and can be explained clearly.
If you want to procedd I can guide you to make these changes or if you're comfortable you can upload the workbook Then I'll make these changes for you.

For you to get an idea of what it's all about I'm attachig a sample workbook.
The sheet has an ActiveX button and a formula in cell R2.
The formula looks if the value of cell K2 is even. If so it returns True else it returns false.
The ActiveX button changes color in accordance with the state of cell R2.

To see what's going on where, open the Developer tab on the ribbon and click View Code.
If you don't have the Developer tab, right-click on any other ribbon menu and select Customize Ribbon. Then check the Developer checkbox.

Glad I could help. Thx for the rep.
To finalize this thread pls mark it SOLVED (see Tread Tools in the menu above).
Unless you have more questions related to the subject of this thread.