Nov 18 2020 05:16 PM
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!
Nov 18 2020 05:53 PM
@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.