Good afternoon. I'm using the following code to fill a cell red if the user exits the cell without choosing a name provided in the drop down list.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address <> "$D$3:$E$3" Then
If Len([D3]) = 0 Then
Range("$D$3:$E$3").Interior.Color = RGB(255, 0, 0)
Worksheets("Demographics").Range("E3").Select
End If
End If
End Sub
If the cell is left blank the fill color changes from the default color (i.e. RGB 196, 189, 151) to RGB (255, 0, 0). What I can't figure out is how to toggle the color from 255, 0, 0 (red) back to the default color 196, 189, 151 (greyish-brown). Thanks for any help you might be able to provide.
Matthew
Bookmarks