I have a combo box and based on the answer in the combo box, I need the
cell color to change to 'gray out' when then answer is no. It works
great without protection turned on, but once I turn on sheet
protection, it doesn't work anymore. I need the rest of the sheet
protected. I unchecked the 'locked' and 'hidden' boxes on the cell I
need to turn gray. I also have the value of the cell changing from 65
to N/A and that part works great.

I'm stumped. What do I do?

Thanks in advance,
Laura