how to add thick line as divider automatically

I have serial number column in an excel and would like to add thick border when user goes next number.

Please see attached file. When user goes to next level of number I want to see think border as partition between to levels. Can a macro do this?

Appreciate your help
var