Conditional Formatting Drop-Down List

[Jamie-NA2101]

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]

@Jamie-NA2101 

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.

[#3]

@Jamie-NA2101 

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