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.
Do you have that information in your workbook? If so, could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar I've linked the document. Was discussing with my boss and he thinks a VLookUp between two separate workbooks would work, but he's unsure how to set that up.
Open to any suggestions you have & appreciate the assistance!
https://shipbestds-my.sharepoint.com/:x:/r/personal/ksurkamer_shipbds_com/_layouts/15/Doc.aspx?sourcedoc=%7B7D9EC303-C6CC-405A-AAD6-3C30D99D51E2%7D&file=Workbook.xlsx&action=default&mobileredirect=true