Forum Discussion
I need to highlight the source cell when it's chosen from a dropdown list
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 highl...
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.