Change bunch if cell colours when cell pressed

KeepinTidy Posts 1 Registration date Wednesday March 1, 2017 Status Member Last seen March 1, 2017 - Mar 1, 2017 at 06:48 PM

I would like to be able to click on a yes cell, no cell and a selected amount of cells in a column change to either green/red. Effectively acting like buttons. This is to show if parts are on order or not from suppliers as part of a university project.

Any help in this matter is greatly appreciated.