Forum Discussion
Solved
Conditional Formatting Table
I have a large table in Excel that includes the columns "Desk" and "Date". I would like to highlight all rows where there are duplicate desks per date. E.g. in the example below, I would need the...
Let's say the desk numbers are in A2 and down, and the dates in D2 and down.
Select the rows that you want to format from row 2 down.
The active cell should be in row 2.
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:$A$10000, $A2, $D$2:$D$10000, $D2)>1
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
=COUNTIFS($B$2:$B$10,$B2,$C$2:$C$10,$C2)>1
You can apply this rule for conditional formatting of the sample data.
=$B$2:$C$10
This is the range the format applies to in the example.