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.
 
Back
Top