Format entire row based on rows

[lbeamer]

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]

@lbeamer 

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

=MOD(ROW(),10)=0

Click Format...

Activate the Fill tab.

Select a highlight color.

Click OK, then click OK again.

[#3]

@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.

Regards

Lbeamer