Forum Discussion
jvass92
Aug 19, 2021Copper Contributor
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. ...
- Aug 19, 2021
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.
Kcsurk
Nov 08, 2023Copper Contributor
Best way for me to share it with you?
HansVogelaar
Nov 08, 2023MVP
Click on my user picture and send me a private message. You should be able to attach the workbook there.
- KcsurkNov 08, 2023Copper ContributorSent!