Dropdown list with formatting preservation

Question

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

michel_m · Answer

Hello and welcome,   You need to replicate your formatting in the data validation cell  an example:

via55 · Answer

Hello to both of you  Or you can use one of the methods provided here: http://boisgontierjacques.free.fr/pages_site/donneesvalidation.htm#ListeCouleur  which has the advantage that you can change the colors within the original range without having to redo all the conditional formatting  Best regards Via  -- "Imagination is more important than knowledge." A. Einstein

michel_m · Answer

Hello Via  Yes, but Amelie specified "not an expert at all in Excel,"  and Boisgontier offers solutions in VBA and the few by formula are "challenging" for beginners   Best regards

Dropdown list with formatting preservation

3 réponses

Texture issues in enshrouded

Big fish games are they worth it?

Saracroche: the effective french app against phone spam

How to get the character µ on the android keyboard.

Access issue to my "contact me" profile

Windows spotlight is not working.

Black screen digital camera

Connecting rj45 cable with fiber

Sony bravia tv red led blinks 4 times

Free: associating with the freebox server in progress