Thick border when new group starts

[shaniwafa]

Hi,
I am reaching out to seek guidance on an issue I am encountering in managing a comprehensive data sheet containing various family details organized into groups. Specifically, I need to insert a thick horizontal border whenever a new family's information begins within the specified range of A1:Z26.

To provide some context, in column T, the cell contains the letter 'H' to signify the start of a new family. It is essential that the rest of the gridlines remain unchanged. As I navigate this task within Excel 2010, I am considering two potential approaches: conditional formatting or VBA coding.

Given the constraints of the Excel version, I am seeking advice on the most straightforward method to accomplish this task. Would it be more efficient to utilize conditional formatting or implement VBA coding? I am open to your expertise and recommendations on the matter.

Your assistance in this matter would be greatly appreciated. Thank you for taking the time to consider my inquiry. I look forward to your guidance and suggestions.

Shaniwafa

 

[shaniwafa]

I am not a huge fan of using conditional formatting on the main data sheet since it a effectively volatile and slows down performance.
If you want to go ahead anyway, you can achieve it by reversing the logic.
1) Apply a thick border to all the rows (I used the bottom of the row)
2) In conditional formatting use if the current row value = the next row value the "remove" the bottom border

PS: The borders didn't really show thick & bold in the XL2BB but I thought it might be more useful than a picture

Book1
	A	B	C	D	E	F	G
1
2	Grouping
3	a
4	b
5	b
6	b
7	c
8	c
9	e
10	e
11
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:G10	Expression	=$A3=$A4	text	NO

View attachment 107953

Hi,
Thanks for all your suggestions and help
Regards
Shani