Forum Discussion
I am looking for a function that can highlight a row based on entries in two separate columns
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.
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.
- Thanks, Hans it works!
