Toggle fill Color in cell based on condition of cell--blank or text added.

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.

Please Login or Register  to view this content.

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

AlphaFrog,

Once again, thanks for the addition to the code. It works perfectly. Thanks.

Matthew