Conditional Formatting to highlight duplicates within 3 rows of each other

[gravanoc]

I have a chart of exercises that shouldn't be repeated within a 3 day timeframe. What I would like is for the conditional formatting to highlight all instances where they are repeated within any 3 day range. My current rule doesn't seem to work as well as I'd like. It highlights the first instance, but not the other. My rule is =COUNTIF($L4:$Z6,L4)>1 for reference.

Here's what it looks like:

 

[bebo021999]

In the image:
- Are cells with yellow manual income, or results from your current CF?
- Where is the row and column number? I could not find what cell is L4 or Z6.

Pls post again to display row-column index and manual hightlight the outcome.

 

[Peter_SSs]

Can you give us some sample data that we can copy to test with. XL2BB

 

[gravanoc]

@bebo021999 - Those are cond. formatting results. I've posted the xl2bb to assist with column & row headers. The cond. formatting rule doesn't need to go to Z for this example.

Training Book v3.xlsm
	L	M	N	O	P
3	Exercise 1	Exercise 2	Exercise 3	Exercise 4	Exercise 5
4	AL - Plank In and Out
5		AL - Plank In and Out
6
7		AL - Plank In and Out
8
9
10
11		AL - Plank In and Out
12
13
14
15		AL - Squat Jack to Reverse Bear Crawl
16
17		AL - Squat Jack to Reverse Bear Crawl
18		AL - Squat Jack to Reverse Bear Crawl
19
20		AL - Squat Jack to Reverse Bear Crawl
January

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
L4:Z34	Expression	=COUNTIF($L4:$Z6,L4)>1	text	NO

 

[Gerald Higgins]

Perhaps add a second condition, to apply exactly the same format, but with the expression
=COUNTIF($L2:$Z4,L4)>1

Or combine both conditions in to one, with an OR statement, like this
=OR(COUNTIF($L4:$Z6,L4)>1,COUNTIF($L2:$Z4,L4)>1)

 

[gravanoc]

Thanks @Gerald Higgins , that works.

 

[Gerald Higgins]

Actually on second thoughts, you can probably modify that to be even simpler, like this . . .

=COUNTIF($L2:$Z6,L4)>1

 

[Gerald Higgins]

Actually, on third thoughts . . . . . . my solution in post #7 probably doesn't work.