Thread: [Solved] RGB color codes?
View Single Post
 
Old 12-17-2014, 11:30 PM
excelledsoftware excelledsoftware is offline Windows 7 64bit Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

So are you looking to do this in VBA? if so you need to put some more code in so that your program know what objects to look at. Start with this

Code:
If Range("A1").Interior.ColorIndex = 4 Then
  If Range("A1").value <> "" Then
    msgbox "This cell equals nothing and is green."
  End If
End If
Reply With Quote