I need a VBA script to save and close the worksheet after a cell changes colour due to conditional formatting (ive already done).

Basically I have a progress bar that fills up more and more everytime a form tick box is ticked.. e.g. 4 tick boxes. once they click 2 its 50% full.

I need the script/macro to recognise when the final cell is green because it is 100%complete - save and close the work book.


any ideas?

thanks.