Dropdown list with formatting preservation

Amelie -  
michel_m Posted messages 18903 Registration date   Status Contributeur Last intervention   -
Hello,

I'm new to this forum and absolutely not an expert on Excel, and I would like my dropdown list to retain the formatting of the source. In this case, some of the source cells have text in red.
I'm using Excel 2010, is that possible?

Thank you in advance for your insights!

Configuration: Android / SamsungBrowser 11.2

3 réponses

michel_m Posted messages 18903 Registration date   Status Contributeur Last intervention   3 320
 
Hello and welcome,

You need to replicate your formatting in the data validation cell

an example:



0