Hi All

I have a spreadsheet that has data from columns A thru to J. The data
is imported from another program so the positioning of text varies each
time the user runs existing macro's within the spreadsheet. I wanted to
add a border on the top of any row (from column A - J) that has any
text that appears in column B (starting from cell B14 and moving down).
For Example if there is text in cells B15 and B20 then the top edge or
A15:J15, and A20:J20 will have borders.

I have tried playing around with conditional formatting and can't get
it to work. The other alternative is with a macro but I am not
experianced enough to set the macro up to keep repeating itself until
it reaches the bottom of column B ie there are no more cells to check
for text (sure this is easy when you know how)

Thanks in advance for any help

Ta

Karen


--
ksp
------------------------------------------------------------------------
ksp's Profile: http://www.excelforum.com/member.php...fo&userid=6267
View this thread: http://www.excelforum.com/showthread...hreadid=537081

Hi!

Try this:

Assume the range in question is A14:J20

Select that range
Goto FormatConditional Formatting
Formula Is: =ISTEXT($B14)
Click the Format button
Select the Border tab
Select your desired line style from the list on the far right
Click the location where you want the line to appear in the "preview box"
OK out

Biff

"ksp" wrote in message
...

Hi All

I have a spreadsheet that has data from columns A thru to J. The data
is imported from another program so the positioning of text varies each
time the user runs existing macro's within the spreadsheet. I wanted to
add a border on the top of any row (from column A - J) that has any
text that appears in column B (starting from cell B14 and moving down).
For Example if there is text in cells B15 and B20 then the top edge or
A15:J15, and A20:J20 will have borders.

I have tried playing around with conditional formatting and can't get
it to work. The other alternative is with a macro but I am not
experianced enough to set the macro up to keep repeating itself until
it reaches the bottom of column B ie there are no more cells to check
for text (sure this is easy when you know how)

Thanks in advance for any help

Ta

Karen


--
ksp
------------------------------------------------------------------------
ksp's Profile:
http://www.excelforum.com/member.php...fo&userid=6267
View this thread: http://www.excelforum.com/showthread...hreadid=537081

Hi Biff

Thanks for that it works but what I didn't think of was that the edges
of each column have preset borders of different weights (the outer most
ones being heavy), CF in this way doesn't look like it is going to let
me set the column edges differently - unfortunately

Thanks anyway

Karen


--
ksp
------------------------------------------------------------------------
ksp's Profile: http://www.excelforum.com/member.php...fo&userid=6267
View this thread: http://www.excelforum.com/showthread...hreadid=537081

Yeah, you don't get the full selection of line weights/styles using cf.

Oh well!

Biff

"ksp" wrote in message
...

Hi Biff

Thanks for that it works but what I didn't think of was that the edges
of each column have preset borders of different weights (the outer most
ones being heavy), CF in this way doesn't look like it is going to let
me set the column edges differently - unfortunately

Thanks anyway

Karen


--
ksp
------------------------------------------------------------------------
ksp's Profile:
http://www.excelforum.com/member.php...fo&userid=6267
View this thread: http://www.excelforum.com/showthread...hreadid=537081

Take a look at http://www.xldynamic.com/source/xld.....Download.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ksp" wrote in message
...

Hi Biff

Thanks for that it works but what I didn't think of was that the edges
of each column have preset borders of different weights (the outer most
ones being heavy), CF in this way doesn't look like it is going to let
me set the column edges differently - unfortunately

Thanks anyway

Karen


--
ksp
------------------------------------------------------------------------
ksp's Profile:
http://www.excelforum.com/member.php...fo&userid=6267
View this thread: http://www.excelforum.com/showthread...hreadid=537081