Excel Drop-down List Formatting
Solved
Audrey
-
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur Last intervention -
Hello,
I just created a drop-down list in my Excel file. But when I go to my other page to scroll through the drop-down menu and select one of the items from my list, the font color stays black while the original item was written in green, for example.
I would like to keep the same colors that are in my original data for the choices I select with my menu.
I'm not sure if I'm being clear, but I'm pulling my hair out!
Thanks for your help.
Audrey
I just created a drop-down list in my Excel file. But when I go to my other page to scroll through the drop-down menu and select one of the items from my list, the font color stays black while the original item was written in green, for example.
I would like to keep the same colors that are in my original data for the choices I select with my menu.
I'm not sure if I'm being clear, but I'm pulling my hair out!
Thanks for your help.
Audrey
2 réponses
Good evening
to do this, you would need to apply conditional formatting to each section of your menu.*
but to be reasonable, it would be necessary to know how many options you have, if each has its own color or if they can be grouped... etc.
In short, if you can upload a model here:
http://mon-partage.fr
and come back to paste the link created on the site, we will provide you with more information
looking forward to hearing from you
best regards
--
The quality of the response mainly depends on the clarity of the question, thank you!
to do this, you would need to apply conditional formatting to each section of your menu.*
but to be reasonable, it would be necessary to know how many options you have, if each has its own color or if they can be grouped... etc.
In short, if you can upload a model here:
http://mon-partage.fr
and come back to paste the link created on the site, we will provide you with more information
looking forward to hearing from you
best regards
--
The quality of the response mainly depends on the clarity of the question, thank you!
I found it.
Have a nice evening
Audrey