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.
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.![]()
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
Matthew
Bookmarks