View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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