Shading the Cells Using Conditional Formatting
Conditional formatting already has a number of ways in which you can alter your cells. These are inbuilt settings for the Microsoft Program, for which you only have to click on the formatting style that you like. As an example, I selected the option for ‘between…’, and entered a range in the space provided. Now on the worksheet, all the cells which will have a value between this range will get highlighted as shown in the image below.
Shading the Cells Using MOD Formula
Understanding the MOD Formula
The MOD formula can be very helpful for users and is pretty easy to understand how it works. It is not important that everyone would always want the alternate ‘rows’ to be shaded. Sometimes, people might even want the columns to be shaded and this might not be wanted at alternate gaps. You can always replace the word ‘ROW’ in the formula with ‘COLUMN’, to implement the same formatting on the columns instead. And change the numbers in the formula as well for the gap and beginning settings. This will further be explained below. =MOD(COLUMN( ),2)=0 Now, the number 2 here, shows that every second column will be shaded according to the colors that you have selected. But, if you don’t want every second row/column to be shaded, but instead want the fourth or the fifth row/column to be shaded, you will change the number 2 here in the formula to 4 or 5, depending on how many rows/columns gap you want in between. Similarly, if you want the software to start the shading from the first column, and not from the second, you will change the number 0 in the formula with 1.
How to Insert and Delete Entire Rows and Columns on Microsoft ExcelHow to Delete Multiple Rows in Excel?How to Save Specific or Selected Excel Columns as a .csv FileIs Fuchsia a Shade of Pink?