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,OFFSE T(E2,1,,)<"",$B2=E2),AND(E2<"",MOD(ROW(),2)=1,CO UNTIF($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