Forum Discussion
Steph1685
Jan 23, 2024Copper Contributor
I am looking for a function that can highlight a row based on entries in two separate columns
Good day I am struggling to figure out how to check in one column if the client ID has been entered multiple times in the ID column if it has been entered multiple times has there been duplicate subm...
- Jan 23, 2024
Let's say the columns are A and B, with data starting in row 2.
Select rows 3 and down. The active cell in the selection should be in row 3.
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($A$2:$A2, $A3, $B$2:$B2, $B3)
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
HansVogelaar
Jan 23, 2024MVP
Let's say the columns are A and B, with data starting in row 2.
Select rows 3 and down. The active cell in the selection should be in row 3.
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($A$2:$A2, $A3, $B$2:$B2, $B3)
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
- Steph1685Jan 23, 2024Copper ContributorThanks, Hans it works!