Have a cell filled black when blank in dropdown list

NoSparks · #12 04-05-2017, 06:33 AM

I realize this is not posted under Excel Programming and this will require the file to be a macro enabled .xlsm, but I would remove the conditional formatting and use the Worksheet_Change event as it triggers when a selection is made in a validation drop down.

Code:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Count > 1 Or Target.Column <> 2 Then Exit Sub
If Not Intersect(Target, Me.Range("B12:B146")) Is Nothing Then
    If Target.Value = "" Then
        Target.Interior.ColorIndex = 1
    Else
        Target.Interior.ColorIndex = 0
    End If
End If

End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formulato say if cell is blank do this, if not blank do this.	mbesspiata	Excel	1	01-17-2015 05:02 AM
Using word art in a table with a filled cell	halfnite	Word	5	10-07-2014 05:24 PM
Auto add a list cell if the last list cell is filled	tasuooooo	Excel	1	07-31-2012 08:40 PM
Change cell color everytime a value is selected in dropdown list	angelica_gloria	Excel	4	01-27-2012 06:47 PM
Forms: combination of a list and a text field to be filled in	bart014	Word	0	04-23-2010 12:55 AM