Forum Discussion
Format entire row based on rows
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.
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.
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