Conditional Formatting Formula

[excelbytes]

Based on the attached, I want to highlight cells N4 & N6. The criteria is if the count for any one week for the same person is greater than 1. Is this possible?

Test Count.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2
3										1/1	1/8	1/15	1/22	1/29	2/5
4						7			Mike					7
5				4					Tom			4
6						5	3		Mike					5	3
7					8				Bill				8
8									Tom
9
10
11
12
13
14
Sheet1

Cell Formulas
Range	Formula
K3:O3	K3	=J3+7
J4:O8	J4	=IF(B4>0,B4,"")

 

[JamesCanale]

MrExcelPlayground24.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2
3										1/1/2025	1/8/2025	1/15/2025	1/22/2025	1/29/2025	2/5/2025
4						7			Mike					7
5				4					Tom			4
6						5	3		Mike					5	3
7					8				Bill				8
8									Tom
Sheet1

Cell Formulas
Range	Formula
K3:O3	K3	=J3+7
J4:N5,J8:K8,M7:O8,J7:L7,O4:O6,J6:M6	J4	=IF(B4>0,B4,"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J4:O8	Expression	=COUNT(FILTER(J$4:J$8,$I$4:$I$8=$I4))>1	text	NO

 

[excelbytes]

Works perfectly, thanks!