Can you change the colour of the values in an Excel drop down list to a different colour instead of the colour black

[ShaniN]

Can you change the colour of the values in an Excel drop down list to a different colour instead of the colour black?

 

[yaswanth92]

Yes, you can give conditional formatting along with the data validation.

 

[ShaniN]

Hi - I am not looking at the formatting applied to a cell when a value from the drop down list is selected. I am looking at the actual values in the drop down list set to another colour instead of nlac

 

[Ateeb Ali]

You cannot change the default