A neat way to do this is to add an additional condition to the conditional format using the AND function such as =AND($A$1="On",[your condition]) then in cell A1 type On to reveal the formatting. I would combine this with a data validation, using List, in A1 to allow only On or Off so that you can use the validation dropdown to toggle on and off.