Forum Discussion
Highlight duplicate cell in another sheet
Hello, I need some assistance if possible please. Data in sheet 1, col B. Data in sheet 2, col B. If data in Sheet 2 Col B is the same as Sheet 1 Col B, highlight the duplicate in sheet 2. ...
Select column B on Sheet2. Cell B1 should be the active cell in the selection.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=ISNUMBER(MATCH(B1, 'Sheet 1'!B:B, 0))
Substitute the real name of Sheet 1.
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
Click on my user picture and send me a private message. You should be able to attach the workbook there.
Sent!
