#EXCEL HIGHLIGHT EVERY OTHER ROW MOD#
In the ‘Value or Formula’ field below it, enter the following formula: = MOD ( ROW ( ), 3 ) – 1 = 0.In the Format rules drop-down, click on ‘Custom formula is’ option (you need to scroll down the list to get this option).This will open the Conditional Formatting pane on the right Click on ‘Conditional formatting’ option.Select the dataset for which you want to color every third row (excluding the header).Suppose you have the following dataset and you want to highlight every third row in this dataset:īelow are the steps to use Conditional Formatting to color every third row in Google Sheets: You need to use Conditional Formatting with a simple formula. In that case, you can use the ‘Alternating colors’ functionality of Google Sheets. What if you want to color every third row or every fourth row? If you insert additional rows in the dataset, Google Sheets will automatically adjust the coloring.Ĭolor Every Third/Fourth Row in Google Sheetsįor highlighting/coloring alternate rows, the method shown above is best and fastest.īut what if you don’t want to color every other row.However, in case you delete records, the colors would stay and you would have to manually remove these. If you expand the dataset and add more record at the bottom, Google Sheets will automatically highlight the alternate rows in the colors you specified.It will simply overwrite the existing colors.
In case you want to change the color of the header or any specific cell or range, you can do that manually.And when you remove the alternating colors (steps mentioned in the yellow box above), it will remove the alternate colors while keeping the original colors intact In case you already have some color applied to the cells, these will be overwritten by the ones you choose when highlighting using the ‘Alternating colors’ functionality.This will open the pane where you have the option to ‘Remove alternating colors.’Ī few things to know when using the ‘Alternating colors’ functionality in Google Sheets: To remove the Alternating color, select any cell in the dataset, click the Format tab and then click on ‘Alternating colors’ option.
0 kommentar(er)
