I need to highlight the source cell when it's chosen from a dropdown list

%3CLINGO-SUB%20id%3D%22lingo-sub-1904773%22%20slang%3D%22en-US%22%3EI%20need%20to%20highlight%20the%20source%20cell%20when%20it's%20chosen%20from%20a%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1904773%22%20slang%3D%22en-US%22%3E%3CP%3EI%20hope%20the%20title%20makes%20it%20clear.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20multi-sheet%20workbook.%20One%20table%20is%20sourcing%20a%20drop-down%20list%20from%20the%20column%20of%20another%20sheet%2C%20using%20data%20validation.%20I%20need%20the%20source%20cell%20to%20be%20highlighted%20when%20it%20gets%20chosen%20from%20the%20list%20on%20the%20main%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20do%20this%20with%20the%20source%20column%20maybe%20recognizing%20a%20duplicate%20value%20with%20another%20sheet%20or%20something%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20taking%20a%20look!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1904773%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1904864%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20to%20highlight%20the%20source%20cell%20when%20it's%20chosen%20from%20a%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1904864%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F858051%22%20target%3D%22_blank%22%3E%40plotkinLACC%3C%2FA%3E%26nbsp%3B%20I%20think%20the%20easiest%20way%20is%20using%20conditional%20formatting%20-%26gt%3B%20custom%20formula%3C%2FP%3E%3CP%3Elet's%20assume%20the%20data%20validation%20list%20used%20for%20the%20drop%20down%20is%20in%20Sheet1!B2%3AB20%20and%20the%20drop%20down%20cell%20is%20Sheet2!D5.%26nbsp%3B%20Then%20highlight%20the%20list%20Sheet1!B2%3AB20%20and%20select%20conditional%20formatting%20-%26gt%3B%20new%20rule%20-%26gt%3B%20use%20a%20formula%20and%20enter%3A%3C%2FP%3E%3CP%3E%3DB2%3DSheet2!%24D%245%3C%2FP%3E%3CP%3Ethen%20click%20Format%20and%20select%20the%20formatting%2Fhighlighting%20you%20want.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I hope the title makes it clear. 

 

I have a multi-sheet workbook. One table is sourcing a drop-down list from the column of another sheet, using data validation. I need the source cell to be highlighted when it gets chosen from the list on the main table.

 

Is there a way to do this with the source column maybe recognizing a duplicate value with another sheet or something?

 

Thanks for taking a look!

1 Reply

@plotkinLACC  I think the easiest way is using conditional formatting -> custom formula

let's assume the data validation list used for the drop down is in Sheet1!B2:B20 and the drop down cell is Sheet2!D5.  Then highlight the list Sheet1!B2:B20 and select conditional formatting -> new rule -> use a formula and enter:

=B2=Sheet2!$D$5

then click Format and select the formatting/highlighting you want.