I need some help here. This macro worked for me but when I try to change the cell reference (ex: "F36" to "F35") the macro doesn't work when "Yes,No, or N/A" is selected. Can someone please help me. Thanks! The "Yes, No, or N/A" is a validation list that I used.
<Code>
Sub OffshoreInput2()
If Worksheets("O & M").Range("F35") = "Yes" Then
Worksheets("Offshore_Input").Range("M36:M37").Interior.ColorIndex = 4
End If
If Worksheets("O & M").Range("F35") = "No" Then
Worksheets("Offshore_Input").Range("M36:M37").Interior.ColorIndex = 1
End If
If Worksheets("O & M").Range("F35") = "N/A" Then
Worksheets("Offshore_Input").Range("M36:M37").Interior.ColorIndex = 0
End If
End Sub
</code>
Bookmarks