Forum Discussion

plotkinLACC's avatar
plotkinLACC
Copper Contributor
Nov 19, 2020

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 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!

excel

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Nov 19, 2020

    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.

Resources