software

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: www.excelforum.com/member.php...foamp;userid=6267
View this thread: www.excelforum.com/showthread...hreadid=537081Hi!

Try this:

Assume the range in question is A14:J20

Select that range
Goto Formatgt;Conditional 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 quot;preview boxquot;
OK out

Biff

quot;kspquot; gt; wrote in message
...
gt;
gt; Hi All
gt;
gt; I have a spreadsheet that has data from columns A thru to J. The data
gt; is imported from another program so the positioning of text varies each
gt; time the user runs existing macro's within the spreadsheet. I wanted to
gt; add a border on the top of any row (from column A - J) that has any
gt; text that appears in column B (starting from cell B14 and moving down).
gt; For Example if there is text in cells B15 and B20 then the top edge or
gt; A15:J15, and A20:J20 will have borders.
gt;
gt; I have tried playing around with conditional formatting and can't get
gt; it to work. The other alternative is with a macro but I am not
gt; experianced enough to set the macro up to keep repeating itself until
gt; it reaches the bottom of column B ie there are no more cells to check
gt; for text (sure this is easy when you know how)
gt;
gt; Thanks in advance for any help
gt;
gt; Ta
gt;
gt; Karen
gt;
gt;
gt; --
gt; ksp
gt; ------------------------------------------------------------------------
gt; ksp's Profile:
gt; www.excelforum.com/member.php...foamp;userid=6267
gt; View this thread: www.excelforum.com/showthread...hreadid=537081
gt;

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: www.excelforum.com/member.php...foamp;userid=6267
View this thread: www.excelforum.com/showthread...hreadid=537081Yeah, you don't get the full selection of line weights/styles using cf.

Oh well!

Biff

quot;kspquot; gt; wrote in message
...
gt;
gt; Hi Biff
gt;
gt; Thanks for that it works but what I didn't think of was that the edges
gt; of each column have preset borders of different weights (the outer most
gt; ones being heavy), CF in this way doesn't look like it is going to let
gt; me set the column edges differently - unfortunately
gt;
gt; Thanks anyway
gt;
gt; Karen
gt;
gt;
gt; --
gt; ksp
gt; ------------------------------------------------------------------------
gt; ksp's Profile:
gt; www.excelforum.com/member.php...foamp;userid=6267
gt; View this thread: www.excelforum.com/showthread...hreadid=537081
gt;
Take a look at www.xldynamic.com/source/xld.....Download.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;kspquot; gt; wrote in message
...
gt;
gt; Hi Biff
gt;
gt; Thanks for that it works but what I didn't think of was that the edges
gt; of each column have preset borders of different weights (the outer most
gt; ones being heavy), CF in this way doesn't look like it is going to let
gt; me set the column edges differently - unfortunately
gt;
gt; Thanks anyway
gt;
gt; Karen
gt;
gt;
gt; --
gt; ksp
gt; ------------------------------------------------------------------------
gt; ksp's Profile:
www.excelforum.com/member.php...foamp;userid=6267
gt; View this thread: www.excelforum.com/showthread...hreadid=537081
gt;