Microsoft Office Forums - View Single Post - [Solved] RGB color codes?

Thread: [Solved] RGB color codes?

View Single Post

Old

12-17-2014, 11:30 PM

excelledsoftware excelledsoftware is offline

excelledsoftware is offline

excelledsoftware uses Windows 7 64bit

Windows 7 64bit excelledsoftware uses Office 2003

excelledsoftware uses Office 2003

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