Place Group thick border- If two or more cells contains same value

[aayaanmayank]

Hi Can anyone please help - I have to place a thick border in the entire row based on values in Column "A" until two or more cells contains the same value. if cell A2 & A3 have the same value so i have to place a thick border which will show that these rows have same values.

[TABLE="width: 293"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD] ID[/TD]
[TD]First_Assignment[/TD]
[TD] Company name[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WERT133026660L[/TD]
[TD]Data Quality[/TD]
[TD]DFGH[/TD]
[/TR]
[TR]
[TD]WERT133026660L[/TD]
[TD]Data Quality[/TD]
[TD]DFGH[/TD]
[/TR]
[TR]
[TD]GHIKL134344566L[/TD]
[TD]Data Quality[/TD]
[TD]OLKJNBV[/TD]
[/TR]
[TR]
[TD]GHIKL134344566L[/TD]
[TD]Data Quality[/TD]
[TD]OLKJNBV[/TD]
[/TR]
[TR]
[TD]GHIKL134344566L[/TD]
[TD]Data Quality[/TD]
[TD]OLKJNBV[/TD]
[/TR]
</tbody>[/TABLE]

 

[Bratamoli]

Thank you @mse330.

Quick question though: If my no-longer-necessary final post should be deleted, how can I do that? Lol.

 

[mse330]

yeah i did tht...Thank u so much again.

Glad to help & thanks for reporting back

Quick question though: If my no-longer-necessary final post should be deleted, how can I do that? Lol.

I am not aware that you can delete a post though keep it as it may might help someone else in the future searching the forums. If you like excel, I highly encourage you start learning VBA which might be difficult at first but you'll LOVE it later on
​

 

[aayaanmayank]

Yes i am learning and know the till intermediate level.