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