Format entire row based on rows

%3CLINGO-SUB%20id%3D%22lingo-sub-2912764%22%20slang%3D%22en-US%22%3EFormat%20entire%20row%20based%20on%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2912764%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20highlight%20every%2010th%20row%20in%20my%20spreadsheet.%26nbsp%3B%20I%20have%20about%206000%20rows.%26nbsp%3B%20Every%2010th%20row%20has%20a%20new%20updated%20formula%20in%20one%20of%20the%20columns.%26nbsp%3B%20Any%20ideas%3F%3C%2FP%3E%3CP%3EThanks%20n%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2912764%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2912819%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20entire%20row%20based%20on%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2912819%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1203278%22%20target%3D%22_blank%22%3E%40lbeamer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20the%20range%20you%20want%20to%20format.%3C%2FP%3E%0A%3CP%3EOn%20the%20Home%20tab%20of%20the%20ribbon%2C%20click%20Conditional%20Formatting%20%26gt%3B%20New%20Rule...%3C%2FP%3E%0A%3CP%3ESelect%20'Use%20a%20formula%20to%20determine%20which%20cells%20to%20format'.%3C%2FP%3E%0A%3CP%3EEnter%20the%20formula%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DMOD(ROW()%2C10)%3D0%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EClick%20Format...%3C%2FP%3E%0A%3CP%3EActivate%20the%20Fill%20tab.%3C%2FP%3E%0A%3CP%3ESelect%20a%20highlight%20color.%3C%2FP%3E%0A%3CP%3EClick%20OK%2C%20then%20click%20OK%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

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

@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