Conditional Formatting Help

[ksp]

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

 

[Biff]

Hi!

Try this:

Assume the range in question is A14:J20

Select that range
Goto Format>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 "preview box"
OK out

Biff

 

[ksp]

Hi Biff

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

Thanks anyway

Kare

 

[Biff]

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

Oh well!

Biff

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)