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

 

[keda duck]

It is more efficient to utilize conditional formatting or implement VBA coding. I think conditional format is better at getting started.

 

[shaniwafa]

It is more efficient to utilize conditional formatting or implement VBA coding. I think conditional format is better at getting started.

Hi, Thanks for your valuable suggestions. Would you mind to text the code. Iam using Excel 2010. Please update
Shaniwafa

 

[keda duck]

Hi, Thanks for your valuable suggestions. Would you mind to text the code. Iam using Excel 2010. Please update
Shaniwafa

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.

it means if column T is written as "H", insert a thick horizontal border in column T or a thick horizontal border in the entire row?

keda duck

 

[shaniwafa]

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.

it means if column T is written as "H", insert a thick horizontal border in column T or a thick horizontal border in the entire row?

keda duck

Entire row

 

[keda duck]

Entire row

=countif($T1,"*H*")
You can check for yourself how to use this formula in conditional formats

 

[shaniwafa]

Thanks for your valuable reply, it's truly helpful anyway. The option for thick border is not in the option list while going for conditional formatting. Is there any other suggestions.
Regards
Shani

 

[keda duck]

If you click the format button in the right corner, you can see 4 tabs at the top. You can try to see if each tab meets your requirements...
the tab of border seems...

 

[shaniwafa]

Hi,
I have been attempting to locate the option for a thick border within the Excel interface, particularly within the conditional formatting section. However, upon inspection, I could not find any provision for selecting a thick border within this context. I wonder if this feature is located within the cells group of the ribbon instead.

If indeed the thick border option is meant to be found within the cells group, I am curious about the possibility of applying such formatting for conditional formatting purposes. It appears that the current version of the software I am using may not support this functionality, or I may have overlooked it.

Could you kindly advise if there is an alternative solution, such as utilizing VBA scripting, to achieve the desired effect of implementing a thick border when a new group starts and maintaining a thin border within the group?
Thank you for your attention to this matter. I appreciate any guidance or assistance you can provide.

Regards
Shani

 

[Alex Blakenburg]

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