asked on

Addiing a bottom thick line to seperate numbers

Wanted to automatically add a thick bottom line when there is a difference in a numerical value in a column.

For example:
On column B there is a series of number and I wanted a line starting with a new number to seperate it from coumn A to column I. for Example Row 63 there is a thick bottom line for the number 4 and one at row 65 for the number 5.

The data is linked to an access database so the data always changes day to day. So the code would delete the the thick bottom line and add new ones accordingly.

See attachment for example.
C--Users-lfreund-Documents-EE---LIN.xlsx

Rob Henson

You could use Conditional Formatting but it doesn't allow for a thick line, only a single line.

Alternatively, you could also use CF to highlight the first or last row of each section a different colour to the standard alternating colour of the table and add bold font for that row.

See attached with two versions of the same data. Version 1 with single border between sections and version 2 with first row of each section highlighted green.

PS Your numbers in section 9 were inconsistent, the first was 9 as text, the second a true number 9 and the third (and subsequent) back to text.
C--Users-lfreund-Documents-EE---LIN.xlsx

ASKER CERTIFIED SOLUTION

Martin Liss

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

LUIS FREUND

ASKER

Mr. Liss,

Thank you very much! This works perfect!

Martin Liss

You’re welcome and I’m glad I was able to help.

If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
Experts Exchange Most Valuable Expert (MVE) 2015, 2017
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
Experts Exchange Top Expert VBA (current)

LUIS FREUND

ASKER

Awesome....Will do!