View original (French)

Dropdown list with formatting preservation

Amelie -  
michel_m Posted messages 18903 Registration date   Status Contributor 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 answers

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello and welcome,

    You need to replicate your formatting in the data validation cell

    an example:



    0