Hi,

Go back to the answer given to you by Gary's Student in your previous post
and use his code. To insert the code right click the sheet tab of the
required sheet, view code and paste the code in on the right.

Mike

"edo" wrote:

I am trying to figure out a formula to have individual items in a dropdown
list in a cell change color when selected. There are more than 3 items so
Conditioning Format will not work for this. Anyone know how to achieve this??