Conditional Formatting - Highlight Row with Duplicate Cells

[RY_VT]

I have a Power Automate flow running that adds rows of Associate information into sheets of an Excel online spreadsheet. I would like to set up conditional formatting so that it highlights rows that have the same "Associate Id#" (First column in each sheet) when that ID number occurs three times. In other words, If an employee has three infractions, they would have three entries on this sheet, and I want the row with the third occurrence of their ID number to be red.

Thanks in advance for any assistance.

 

[etaf]

you should be able to use a formula
=countif() or countifs() = 3

so if you want the row

select the range - for example A1:1000
then a formula in conditional formatting
=countif(A1:$A$1, $A1)=3
But i'm not sure of the

Power Automate flow running

So it may need another formula or a macro - which i cannot help with

Book1
	A	B	C	D	E	F	G
1	ID
2	1
3	4
4	3
5	4
6	1
7	2
8	4
9	5
10	2
11	5
12	2
13	7
14
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:I1,A2:B13,D2:I13,C2:C16	Expression	=COUNTIF($A$1:A1,$A1)=3	text	NO

 

[RY_VT]

you should be able to use a formula
=countif() or countifs() = 3

so if you want the row

select the range - for example A1:1000
then a formula in conditional formatting
=countif(A1:$A$1, $A1)=3
But i'm not sure of the

So it may need another formula or a macro - which i cannot help with

Book1
	A	B	C	D	E	F	G
1	ID
2	1
3	4
4	3
5	4
6	1
7	2
8	4
9	5
10	2
11	5
12	2
13	7
14
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:I1,A2:B13,D2:I13,C2:C16	Expression	=COUNTIF($A$1:A1,$A1)=3	text	NO

Working perfectly! Thanks so much for the help!

The power automate aspect is what's pushing the data into the spreadsheet, but that was working properly.

-Ryan

 

[etaf]

you are welcome

 

[RY_VT]

you are welcome

Sorry, one more question- Is it possible to add a string of text to a cell in the row that is highlighted red? If columns A - E are data, could the cell in column F say "3rd Infraction" when the rule triggers?

 

[etaf]

try in F1 and copy down
=IF(COUNTIF($A$1:A1,$A1)=3,"3rd Infraction","")

Book1
	A	B	C	D	E	F	G	H	I
1	ID
2	1
3	4
4	3
5	4
6	1
7	2
8	4					3rd Infraction
9	5
10	2
11	5
12	2					3rd Infraction
13	7
Sheet1

Cell Formulas
Range	Formula
F1:F13	F1	=IF(COUNTIF($A$1:A1,$A1)=3,"3rd Infraction","")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:I1,A2:B13,C2:C16,D2:I13	Expression	=COUNTIF($A$1:A1,$A1)=3	text	NO