Conditional Formatting in Excel
Posted
by littlevahn
on Stack Overflow
See other posts from Stack Overflow
or by littlevahn
Published on 2010-05-12T19:58:50Z
Indexed on
2010/05/12
21:24 UTC
Read the original article
Hit count: 284
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.
© Stack Overflow or respective owner