Add row borders based on number of instances

[Pierce Quality]

We have tried to apply conditional formatting to Cell A2 to add borders to A2:F100 in the attached example. This is on the right track but not quite where we want to be, we currently copy and paste our data (which changes everyday, example on the 'PasteThis' Tab) and are looking to to have the end product look like the 'Goal' Tab, with thick borders around the outside of rows A:F based on the number of instances. Any help in achieving this end product would be greatly appreciated!
Thanks.

[Pierce Quality]

Bumping along

[GC Excel]

Hi Pierce,
It is not possible to have thick borders with conditional formatting.
See if this would work for you :

[Pierce Quality]

Hi Pierce,
It is not possible to have thick borders with conditional formatting.
See if this would work for you :

This is very close for sure! We can live without the thick borders, but is there a way to add side borders on the outside of the rows?
Thank you very much!

[GC Excel]

By adding 2 more conditions on column A and F :

[Pierce Quality]

By adding 2 more conditions on column A and F :

This is perfect, thank you very much! If you have a few moments, could you explain the condition rules you used so we could understand them a little better?
Thank you, very much appreciated!

[GC Excel]

In Cell A2:
Condition #1 : if $A2<>$A1 ==> if cell is different then cell above then add horizontal line in column A to F
Condition #2 : if $A2 <> "" ==> if cell in column A is not empty then add vertical line to the left of cell in column A

In Cell F2:
Condition #2 : if $A2 <> "" ==> if cell in column A is not empty then add vertical line to the right of cell in column F

[Pierce Quality]

In Cell A2:
Condition #1 : if $A2<>$A1 ==> if cell is different then cell above then add horizontal line in column A to F
Condition #2 : if $A2 <> "" ==> if cell in column A is not empty then add vertical line to the left of cell in column A

In Cell F2:
Condition #2 : if $A2 <> "" ==> if cell in column A is not empty then add vertical line to the right of cell in column F

Thank you very much, we appreciate the knowledge!