Have a cell filled black when blank in dropdown list

NoSparks · #1 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

Aussie_81 · #2 04-06-2017, 12:44 AM

Hey No Sparks,

Thankyou for the that.

That is exactly what I wanted.

Much appreciated.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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