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.
 
You must log in or register to reply here.

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
Excel Conditional Formatting 1
Conditional Formatting in Excel when data changes 0
Conditional format a column based on value in a different column 3
Excel Highlighting duplicates 0
Finding the 70th percentile 4

Back
Top