Conditional Formatting in Excel
- by littlevahn
I'm very new to Excel and VBA and was wondering if there is a way I could make conditional formatting based on values in a drop down list.
I currently have a warning if the user enters something that is not valid (data validation), but I want to change the cell's background color to red if invalid, or green if valid.
Again the options I want to test against are in a Listbox.