Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Thick Border? | Excel Worksheet Functions | |||
conditional format overriding border | Excel Discussion (Misc queries) | |||
Conditional Border | Excel Worksheet Functions | |||
Conditional Format - Outline Border | Excel Worksheet Functions | |||
Conditional Format - Outline Border | Excel Worksheet Functions |