Conditional Formatting and Drop Down Lists

Question

I'm creating a very large inventory list that requires a drop down list with multiple locations. I want to color code this list so that when i select a location from my drop down list, all of the cells in that particular line in the table highlight to a certain color. I know how to create the drop down list in a separate sheet and format the cells so they highlight that color, I'm just getting stuck with translating that formatted drop down list to my actual inventory sheet. I know this isn't the rocket science of excel, but boy oh boy is it getting the best of me.

Answer 1

Hi,

You may refer to the below links and articles to check if it helps.

http://answers.microsoft.com/en-us/office/forum/office\_2010-excel/change-the-color-of-a-row-based-on-a-drop-down/27849b7f-ae90-4b7c-90d9-9d3220fb667e

https://support.office.com/en-us/article/Create-a-drop-down-list-7693307A-59EF-400A-B769-C5402DCE407B

https://support.office.com/en-us/article/Create-and-manage-drop-down-lists-28db87b6-725f-49d7-9b29-ab4bc56cefc2?ui=en-US&rs=en-US&ad=US

https://support.office.com/en-us/article/Apply-conditional-formatting-with-color-in-Excel-34402F91-C7E7-4060-944C-65D913033D18

https://blogs.office.com/2009/11/24/create-conditional-drop-down-lists/

https://support.office.com/en-us/article/Use-a-formula-to-apply-conditional-formatting-FED60DFA-1D3F-4E13-9ECB-F1951FF89D7F

Hope the information helps.

Thank you.

Answer 2

Hi,

Please share some data and show your expected result.