![]() |
#2
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Anderso | Excel | 1 | 12-19-2014 11:53 PM |
Converting color codes in VBA | Ulodesk | Word VBA | 7 | 11-24-2014 04:15 AM |
Is it possible to merge the two VBA codes into just one | sam2149 | Excel Programming | 0 | 02-26-2014 05:28 AM |
![]() |
Cassik | PowerPoint | 5 | 11-04-2013 02:08 PM |
![]() |
tinfanide | Word VBA | 7 | 10-23-2012 03:13 PM |