Drop down menus where a selected item in the menu set a colour in the cell

[E0220173]

I have an EXCEL worksheet that has a menu of items such as; Achieved, Not achieved, Implementing, NA.

The cells where that drop down menu appears have a button that opens the menu. Each of the elements of the menu is coded a different colour so that if achieved is selected, for example the cell will fill with green colour and if not achieved is selected will fill with red. 

This action has stopped working - it was originally designed on non-Apple platform. 

Is there a way for me to reengage the actions that I want?

[#2]

@E0220173 

I suspect that your rules for conditional formatting were cleared. Would it be possible to upload an example your file. Without any confidential information, of course)?