Hi, I am trying to change the cell color using VBA programming and I keep receiving an error for my code. The error I get is "object doesn't support this method"
![]()
Private Sub CommandButton1_Click() If Range("R2").Value* > Range("Q2").Value Then Range("A2").Interior.ColorIndex = 3 End Sub
Bookmarks