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.

You can achieve a spectrum of colour with a single CF if that is what you require.