highlight specific row range

**stephme55** · 01-28-2016, 01:59 PM

Hello. How do I highlight a specific row range, for example row 16000 to row 7333? Thanks.

**dosydos** · 01-28-2016, 02:06 PM

not sure i 100% understand your question.
But if im reading this right you want to select row 7333:16000, and then fill in with a color?

if so you can either scroll to roww 7333 click on the row and then scroll to 16000 and shift click on that row to select that range.
You can also select the find and select button on the home ribbon hit go to and then type in 7333:16000.
once the range is selected you can hit the fill color button on the home ribbon

**hemesh** · 01-28-2016, 02:20 PM

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