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.
Hi there I need some assistance please.
Need to link a number value to a different sheet and worksheet to highlight if they are both on the different sheets
This is far far far above my excel knowledge please!
Let's say you want to highlight values that occur in column C on the Aug and Sept sheets, in rows 2:1000.
Select C2:C1000 on the Aug sheet. C2 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(XMATCH(C2, Sept!$C$2:$C$1000))
Click Format...
Activate the Fill tab.
Select a color.
Click OK, then click OK again.
It's similar for the Sept sheet, with the formula =ISNUMBER(XMATCH(C2, Aug!$C$2:$C$1000))