Conditional add border in a range

[Hank]

Hello everyboy,

I need help adding border in an area. The situation is I have data on column
A with sort of number, I want to add border where they are same #, such as
below, I want to add border from A1 to C3 for 111 and next add border from A5
to C6 for 555, and add border from A7 to C9 for 44.... thanks

A B C
111
111
111
555
555
44
44
44

 

[Max]

One simple tinker which brings you v.close? to the effects that you're after

Assume your source data as posted in A1:A10
Select A2:C10 (with A2 active), then apply CF using Formula Is:
=$A2<>$A1
Click to Format the top edge only with a solid line (in border tab) > ok out

Any good? hit YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Hank]

Thanks Max, it was good!

One simple tinker which brings you v.close? to the effects that you're after

Assume your source data as posted in A1:A10
Select A2:C10 (with A2 active), then apply CF using Formula Is:
=$A2<>$A1
Click to Format the top edge only with a solid line (in border tab) > ok out

Any good? hit YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Max]

Glad to hear. You're welcome, Hank.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik