Forum Discussion
Conditional Formatting Drop-Down List
When selecting an option from a drop-down list, can conditional formatting be applied to the cell and change color based on the selected data?
2 Replies
Yes, but you'd have to create a separate rule for each individual value in the dropdown list.
Writing VBA code to color the cell might be more efficient.
