You can highlight the specific rows using Conditional formatting too
first select all cells of sheet
then click Conditional formatting
Click New rule----> use a formula to determine which cell to format
use below formula
=AND(ROW($A1)>=5,ROW($A1)<=10) This will highlight row 5 to row 10(in your case it should be =AND(ROW($A7333)>=5,ROW($A16000)<=10)
then click format button select colour and hit ok
see attached it is highlighting row 5 to 10 change the formula in CF to meet your requirement
Bookmarks