Ok, if we don't have to be concerned with empty cells we can reduce the
formula to:

=OR(AND(MOD(ROW(),2)=0,$B2=E2),AND(MOD(ROW(),2)=1, $B2=OFFSET(E2,-1,,)))

And it will handle multiple duplicates.

Biff

"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:717a3f2cd22dc@uwe...
Hi Biff,

Thank you for your assistance.

T. Valko wrote:
This seems to work and accounts for empty cells. I'm assuming a rank is
not duplicated.

Could your Formula be adapted to take into account duplicate Ranks (other
Numeric Labels having the same Rank)?

Select the range E2:I11
Goto FormatConditional Formatting
Formula Is:

=OR(AND(MOD(ROW(),2)=0,COUNTIF($B:$B,$B2)=2,OFFS ET(E2,1,,)<"",$B2=E2),AND(E2<"",MOD(ROW(),2)=1,C OUNTIF($B:$B,$B2)=2,$B2=OFFSET(E2,-1,,)))

Click the Format button
Apply the border of your choice
OK out

Further assistance very much appreciated.

Cheers,
Sam

--
Message posted via http://www.officekb.com