ExcelBanter - How to make text to change its color accord. to selection from a l

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to make text to change its color accord. to selection from a l (https://www.excelbanter.com/excel-discussion-misc-queries/43838-re-how-make-text-change-its-color-accord-selection-l.html)

planner

How to make text to change its color accord. to selection from a l

"Ruslan" wrote:

Hello everyone,

I have a drop-down list consisting of 4 possible options...
Excel automatically sets black color for fonts....
Is it possible to apply different colors to different options?
in other words, in the choice is 1 - black, 2 - red, 3 - green, 4 - yellow

thank you in advance

All times are GMT +1. The time now is 02:09 AM.