K
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
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