How do I format every 140th row?

  • Thread starter Thread starter From the farm
  • Start date Start date
F

From the farm

I need to highlight every 140th row which, I assume, I would use conditional
formatting but I don't know how to do it.
 
Select all of the cell on the worksheet (click the upper left button where
the row and column headers meet) and use this Conditional Formatting
formula...

=MOD(ROW(A1),140)=0
 
Select all of the cell on the worksheet (click the upper left button where
the row and column headers meet) and use this Conditional Formatting
formula...

=MOD(ROW(A1),140)=0
 
try using =Mod(row(),140)=0 for your condition. This would highlight row
140, 280, etc... Row 1 would need a different condition.
 
try using =Mod(row(),140)=0 for your condition. This would highlight row
140, 280, etc... Row 1 would need a different condition.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel formula 1
Highlighting the entire row with conditional formatting 10
Conditional formatting for rows 7
Conditional Formatting in Excel when data changes 0
Excel Highlighting duplicates 0
Excel Conditional Formatting 1
Conditional format a column based on value in a different column 3
how do I copy every 2nd row 5

Back
Top