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

Copper 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.