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.

ID	First_Assignment	Company name
WERT133026660L	Data Quality	DFGH
WERT133026660L	Data Quality	DFGH
GHIKL134344566L	Data Quality	OLKJNBV
GHIKL134344566L	Data Quality	OLKJNBV
GHIKL134344566L	Data Quality	OLKJNBV

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[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.