How to put different colors for different options in drop down
Like when A option is selected fill color is red and when option B is selected fill color becomes Blue
How to put different colors for different options in drop down
Like when A option is selected fill color is red and when option B is selected fill color becomes Blue
Last edited by Excelforum*ser_mH7; 04-24-2018 at 06:52 AM.
An example here:
http://www.exceltip.com/tips/create-...ith-color.html
How to post a well described question
this is not twitter.. you can use more than 140 characters to formulate your question well..
do you mean the cell that has the drop down?
http://www.exceltip.com/tips/create-...ith-color.html
or the actual drop down list itself
http://www.andypope.info/vba/colourdropdown.htm
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
In attached workbook select value from dropdown in column A
How it works? RightClick SheetTab \ ViewCode
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks