![]() ![]() I realized it was a shading issue, but you cannot un-shade the entire document at one. I didn't even realize I had a light shading on until I got counted off on one of my papers. BackgroundPatternColor = wdColorAutomatic ForegroundPatternColor = wdColorAutomatic ![]() ![]() > 'Macro created by Stefan Blom, MVP, January 2015 > To remove font and paragraph shading you can run the following macro: > then click the arrow on the Text Highlight Color button and choose the > removed as follows: Select the whole document by pressing Ctrl+A and > Highlighting applied via the Highlighting tool on the Home tab can be This will open the conditional formatting pane where you can edit the rule or delete it.On Wednesday, at 2:41:13 AM UTC-5, Stefan Blom wrote: In case you don’t edit the formatting or want to delete it, click any of the cells in the dataset (that has the formatting applied), click on Format and then click on Conditional Formatting. Note: You can also use the same logic to highlight alternate rows as well, however, since Google Sheets has an in-built functionality, for alternating rows, it’s best to use the inbuilt one. #Every other cell shading in g docs modYou can use the same logic to highlight every fourth row in Google Sheets by using the below formula: = MOD ( ROW ( ), 4 ) - 1 = 0 The reason I have subtracted 1 from the MOD formula is that I am starting from the second row onwards. The same logic is applied to all the cells and only the ones in every third record will return TRUE.Īnd since Conditional formatting only applied the specified format to those cells for which the formula returns TRUE, every third row gets highlighted in the specified format. Similarly, the second row would also return a FALSE and the third row will return a TRUE. So the first row in our dataset returns a FALSE. So for the second row, the MOD formula returns 1, which is not equal to 0. So for the second row, the formula becomes = MOD (2, 3 ) – 1 = 0 MOD formula divides the given number with the specified divisor (which is 3 in our example) and gives us the remainder. This row number is then used in the MOD formula. The above formula uses the ROW function to get the row number of each cell. The entire magic is in the below formula: = MOD ( ROW ( ), 3 ) - 1 = 0 The above steps would apply the specified format/color to every third row in Google Sheets (as shown below). You can color every third row or can make it bold, italicize it, apply strikethrough format, etc. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |