Format entire row based on rows

Occasional Contributor

I would like to highlight every 10th row in my spreadsheet.  I have about 6000 rows.  Every 10th row has a new updated formula in one of the columns.  Any ideas?

Thanks n advance.

2 Replies


Select the range you want to format.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula




Click Format...

Activate the Fill tab.

Select a highlight color.

Click OK, then click OK again.

@Hans Vogelaar 


Thank you so much for this.  I am using this spreadsheet to highlight a 10 day trading analysis.  this was hard to see over the 6000 rows and i was having to read every 10th row doing the math in my head.