Hi All,

i would like to change the colour of a command butoon based on whether or not a cell has content in it. The code i have so far is:

 

  If Sheets("work").Range("m8") = "" Then
  Exit Sub
  
  Else
    
  Me.CommandButton3.BackColor = &HFF66FF
  
  
  End If
Also when trying to change the colour of the button manually without any coding, it does not change, it just stays the normal grey colour.

Thanks in advance.

Adam[COLOR="Silver"]