Search and Highlight

I never tried anything like this without using VBA so I tried to make it work with conditional formatting. If you have column A (first) and B (second) sorted then it should work.

Select your entire range, starting at A2 and open conditional formatting. Set Condition 1 to Formula and use this formula

=OR(IF(AND($A2=OFFSET($A2,-1,,,),$B2=OFFSET($B2,-1,,,)),IF($C2=SMALL($C1:$C2,1),TRUE,FALSE),FALSE),IF(AND($A2=OFFSET($A2,1,,,),$B2=OFFSET($B2,1,,,)),IF($C2=SMALL($C2:$C3,1),TRUE,FALSE),FALSE))

Its terribly long but it seems to work. I didnt do many test cases though. Hope this helps you,

Jason

That will do it. Thanks. I was on the right track.

Thanks J