Forum Discussion
Highlight duplicate cell in another sheet
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.
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.
