Conditional Highlighting through a Range

[NeoFlex]

Hey guys,

I'm trying to create a calendar of sorts in excel for scheduling 'deals' to send out. I'm having trouble creating a conditional formatting function that can look horizontally to see if another cell contains the same content, if it does, highlight that original cell. Now the problem is the "time frame"/(cells) to check needs to be dynamic so I can use this one condition across the entire row but only looking back 60 days. I'm using a match function to check if it's true.

Attached is an example worksheet I'm working with, with conditional formatting already in place in cell BV22. Any help would be much appreciated.

KCCO - It's Friday at least.

[AndyLitch]

Select B2 to CO10
select Conditional Formatting -> new rule
Select the last option - enter your own rule
Put the following formula in the formula box
....................=COUNTIF(OFFSET(B2,0,1,1,60),B2)>0

[NeoFlex]

Hey, thanks Andy but what I'm trying do is the SKU category. When I try to convert your formula to that section it highlights the entire section except for a few cells. Any remedy you can see? Thanks again for your help, this hasn't been a great day thus far

KCCO