I need a macro code that will:
1 - Highlight merged field at A3 to D3
2 - Find end of data in column H and then move down 1 rows and right 2 columns to highlight (Blue) J4 and K4 down the column to the end of that data at the left. Example: Highlight J4 & K4 down to J52 and K52 if that is where the end of data stops in H51.
3 - Then move down 2 more rows and back to I? and highlight (yellow) I, J and K.
Example
1 - Highlight merged field at A3 to D3
2 - Find end of data in column H and then move down 1 rows and right 2 columns to highlight (Blue) J4 and K4 down the column to the end of that data at the left. Example: Highlight J4 & K4 down to J52 and K52 if that is where the end of data stops in H51.
3 - Then move down 2 more rows and back to I? and highlight (yellow) I, J and K.
Example