I have column A that contains 3 options buttons grouped together (yes, no, n/a) for each row. Column B contains cells that I want to be green if yes, red if no, and white for n/a for each group of option buttons.
Private Sub optionButton1_Click()
If OptionButton1.Value = True Then...