Conditional Formating 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
20:04 UTC
Read the original article
Hit count: 253
HI, Im very new to Excel and VBA and was wondering I there is a way I could make conditional formatting on drop down Lists.
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 there only options are in a List box.
Any help would be awesome.
Thanks
© Stack Overflow or respective owner