VBA question on bolding differences between sheets

[Curtisyoung78]

Hi I am new here and have a question regarding VBA coding. I am building a spreadsheet and I would like to be able to use VBA Code to bold the differences between sheet 2 and sheet 1. It is a steel pile schedule where each sheet is a revision and the changes to each revision needs to be bolded and a thick border placed around rows (non consecutive rows, column A to R) containing bolded cells, and when rows with bolded cells are consecutive there needs to be bold border above top row (row that contains bolded cell) and thick border below bottom row (row that contains bolded cell) this emphasizes the changes in the new revision. The range is A12 to Q:2000)

I currently am able to bold the differences using conditional formatting but would rather automate the full process for better accuracy and efficiency.

My goal is to do all this with a VBA code and assign to a button or have it update automatically if possible. Can someone please help with the VBA code this would really speed up the process. This is quite a bit to ask but I'm just starting to learn VBA and this would really be an excellent learning experience, thanks in advance for any help.

See below for an example.

P6067 TYPE 1 273 9.3 11.0 12.0 100.400 121.620 92.070 FLARE K.O. DRUM (601V-100) 150 20 0 P6068 TYPE 1 219 8.2 9.0 10.0 100.200 112.460 103.945 PIPE SUPPORT PS-6004 80 8 0 P6069 TYPE 1 219 8.2 9.0 10.0 100.200 112.460 100.505 PIPE SUPPORT PS-6004 80 8 0 P6070 TYPE 1 219 8.2 9.0 10.0 100.200 113.000 89.420 PIPE SUPPORT PS-6005 80 8 0 P6071 TYPE 1 219 8.2 9.0 10.0 100.200 113.000 87.420 PIPE SUPPORT PS-6005 80 8 0 P6072 TYPE 4 273 THICK BORDER HERE 9.3 (BELOW CELLS ARE BOLDED BECAUSE THEY WERE ADDED IN REV1, ABOVE REV 0 INFO CARRIED OVER) 10.0 11.0 99.575 39.000 40.000 LIGHT STANDARD 140 15 1 P6073 TYPE 4 273 9.3 10.0 11.0 100.215 107.000 41.000 LIGHT STANDARD 140 15 1 P6074 TYPE 4 273 9.3 10.0 11.0 99.900 149.500 51.700 LIGHT STANDARD 140 15 1 <colgroup><col><col><col><col><col><col><col><col span="3"><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody> <strike></strike>THICK BORDER HERE

<tbody>
</tbody>