Conditional add border in a range
 

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

Conditional add border in a range
 

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" wrote:
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

Conditional add border in a range
 

Thanks Max, it was good!

"Max" wrote:

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" wrote:
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

Conditional add border in a range
 

Glad to hear. You're welcome, Hank.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Hank" wrote in message
...
Thanks Max, it was good!