I have a cell with list validation in which there are a small number of text selections. Also on the worksheet is an ActiveX button. I want two of the items in the list, when selected, to change the button face to red and the font to bold white. If they get deselected, then I want them to return to the defaults. I've tried everything I can think of, but nothing is working. I thought Application.Volatile would do the trick, but still nothing. From what I can see, it is not recognizing that there is anything in the cell. It's actually several cells merged together, which I also tried in the code to no avail. I know there's an answer and am obviously missing something. Any ideas?

Thanks!