SOLVED

Transferring drop down list cell formatting to other cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1409869%22%20slang%3D%22en-US%22%3ETransferring%20drop%20down%20list%20cell%20formatting%20to%20other%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1409869%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20drop%20down%20list%20with%20a%20corresponding%20table%20that%20has%20the%20conditional%20cell%20formatting%20rules%20where%20a%20cell%20turns%20a%20certain%20color%20based%20on%20the%20choice%20selected%20in%20the%20drop%20down%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20make%20another%20cell%20in%20the%20same%20row%20turn%20that%20color%20based%20on%20the%20other%20cell%20drop%20down%20menu%20choice%2C%20yet%20still%20retain%20the%20text%20in%20the%20secondary%20cell%20turning%20color%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1409869%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1410469%22%20slang%3D%22en-US%22%3ERe%3A%20Transferring%20drop%20down%20list%20cell%20formatting%20to%20other%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1410469%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F136628%22%20target%3D%22_blank%22%3E%40Elijah%20Lewis%3C%2FA%3E%26nbsp%3Bhello%20this%20is%20a%20link%20that%20will%20help%26nbsp%3B%3CA%20href%3D%22http%3A%2F%2Fwww.articleoffice365.site%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewww.articleoffice365.site%3C%2FA%3E%26nbsp%3Bthank%20me%20later.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1410627%22%20slang%3D%22en-US%22%3ERe%3A%20Transferring%20drop%20down%20list%20cell%20formatting%20to%20other%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1410627%22%20slang%3D%22en-US%22%3E%3CP%3ESomeone%20sent%20me%20a%20link%20to%20office.com%2C%20already%20been%20there%20and%20couldn't%20find%20what%20I%20was%20looking%20for%20which%20is%20why%20I%20am%20asking%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1414914%22%20slang%3D%22en-US%22%3ERe%3A%20Transferring%20drop%20down%20list%20cell%20formatting%20to%20other%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1414914%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3EThe%20question%20is%20slightly%20unclear.%20However%2C%20you%20will%20need%20to%20create%20another%20Conditional%20Formatting%20using%20New%20Rule%20and%20Choose%20a%20Formula..based%20on%20the%20other%20drop%20down%20cell%20value%3C%2FLINGO-BODY%3E
Occasional Contributor

I created a drop down list with a corresponding table that has the conditional cell formatting rules where a cell turns a certain color based on the choice selected in the drop down list.

 

How do I make another cell in the same row turn that color based on the other cell drop down menu choice, yet still retain the text in the secondary cell turning color?

2 Replies

Someone sent me a link to office.com, already been there and couldn't find what I was looking for which is why I am asking here.

Best Response confirmed by Elijah Lewis (Occasional Contributor)
Solution
Hello,
The question is slightly unclear. However, you will need to create another Conditional Formatting using New Rule and Choose a Formula..based on the other drop down cell value