Have you ever wanted to add some visual flair to your Google Sheets by highlighting every nth row or column? Well, you’re in luck! In this article, I’ll reveal a simple yet powerful technique using the MOD function and conditional formatting to achieve this. Get ready to take your spreadsheet game to the next level!
Highlighting Rows
Let’s start with rows. To highlight rows in Google Sheets, we’ll combine the ROW function with MOD. The following formula will highlight every 3rd row:
=MOD(ROW(),3)=0
Feel free to adjust the divisor in this formula to suit your preference. It determines the frequency of row highlighting, so if you set it to 4, for example, every fourth row will be highlighted.
It’s important to note that this formula assumes you want to start highlighting from the first row in your sheet. But what if you want to start from a specific row? No worries, we’ve got you covered!
Highlighting Rows from a Specific Row
If you want to start highlighting from a row other than the first row, use the formula below:
=MOD((ROW(A5:A10)-ROW($A$5)+1),3)=0
In this formula, we consider A5 as the first row for highlighting. It will highlight every 3rd row in the range A5:E10. Adjust the range and divisor in the formula according to your needs.
Highlighting Columns
Now, let’s move on to highlighting columns. Just like with rows, you can easily highlight every nth column in Google Sheets. We’ll make use of the COLUMN function and the trusty MOD formula.
To highlight every third column starting from column A, use this formula:
=MOD(COLUMN(),3)=0
This formula will highlight every third column in Google Sheets, starting from column A.
If you want to start highlighting from a specific column number, here’s the formula you can use:
=MOD((COLUMN(D1:D10)-COLUMN($D$1)+1),3)=0
In this formula, we consider D1 as the first column for highlighting. It will highlight every 3rd column in the range B1:J20. Feel free to adjust the range and divisor based on your requirements.
That’s it! With these formulas, you can effortlessly add visual distinction to your Google Sheets by highlighting every nth row or column.
If you’re hungry for more Google Sheets tips and tricks, head over to Crawlan.com. Discover a treasure trove of helpful resources to supercharge your spreadsheet skills. Happy highlighting!
