#Excel highlight every other row how to#
You May Also Like: How to Highlight Cells Based on Expiry Date in Google Sheets Highlight Every Nth Row That Starts from Other than The First Row (Highlight Every Nth Row in Custom Range)Īs mentioned above, if you want the counting to start from any specific row other than the first row and then highlight every nth row, you can use this formula. So the first highlighted row in my sheet will be B6 and then B9, B12, B15 and B18. Even if I select the range B4: D20, the row counting will start from B1. This formula will highlight every third row in my sheet from row 3. Go to the menu Format > Conditional Formatting How to apply this conditional formatting custom formula in Google Sheets?įirst, select the range where you want the highlighting to apply. If you want to start the highlighting from any specific row, there is an alternative formula (formula #2). That means the row count will start from row 1 and start highlighting every third row. Note: Useful only to start the highlighting from row 1 in your sheet. If you opt 4, the formula will highlight every fourth row. Accordingly, the row highlighting will change from 3 to the number you have provided as the divisor in MOD. You can change the divisor in this formula from 3 to any number. Here is the formula to highlight every 3rd row in your Google Doc Spreadsheet. Nth Row Highlighting The formula to Highlight Every Nth Row from the First Row in Google Sheets Here first you can learn how to highlight every nth row in Google Sheets. For highlighting columns, the COLUMN function replaces ROW in MOD. To highlight rows, we can use the ROW function together with MOD. Highlight Every Nth Row or Column in Google Sheets Here the function what I am going to use is MOD and it’s all about using the dividend in MOD.
At least you can understand how a function is flexible.
You can use my custom MOD formulas in Conditional Formatting.Įven though you may think that there is no point in using this in your sheet, try to learn it. By any reason, if you want to highlight every nth row or column in Google Sheets, you can easily do it with the MOD function.
0 kommentar(er)
