Forum Discussion
Need a compare from two different sheets
Select A1:B100 (or however far down the data on sheet one go). A1 shoud be the active cell in the selecton.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=COUNTIFS('Sheet 2'!$A$1:$A$100,$A1,'Sheet 2'!$B$1:$B$100,$B1)
Change Sheet 2 to the actual name of the second sheet, and adjust the ranges if needed.
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK twice.
Select A1:B100 (or however far down the data on sheet one go). A1 shoud be the active cell in the selecton.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=COUNTIFS('Sheet 2'!$A$1:$A$100,$A1,'Sheet 2'!$B$1:$B$100,$B1)
Change Sheet 2 to the actual name of the second sheet, and adjust the ranges if needed.
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK twice.
- Thank you that worked perfectly
