Now click on the Format button and apply required formatting as per your need. Now type the following function in edit the Rule Description box =MOD(ROW()/2,1)>0. Step 4: Select “ Use a formula to determine which cells to format” option in Rule type. Must Read: 3 Ways to quickly find duplicate values in Excel Step 3: Click on the Home Tab > Conditional Formatting > Click on the New Rule… option. If you want to apply alternate color shading between rows in whole worksheet then press Ctrl+A shortcut key.
:max_bytes(150000):strip_icc()/AlternativeShading-5be1f566c9e77c00518914b7.jpg "excel for mac alternate row color")
Step 2: Select the range of cells on which you want to apply alternate color shading between rows in active worksheet.You can use Shift + Arrow key to select specific area of continuous range of cells. Step 1: Create the following table on which you want to apply alternate color shading between rows in Excel. If you need to apply alternate color shading between rows in Excel then you have to take given simple steps. There are lot of situations in which you can use conditional formatting features on active worksheet. In this guide we have to discuss an this issue with the help of Conditional Formatting features. There is lot of ways from which you can apply alternate color shading between rows in Excel.
EXCEL FOR MAC ALTERNATE ROW COLOR HOW TO
Must Read: How to Sum or Count cells based on background color in Excel How to Apply Alternate Color Shading Between Rows in Excel You can apply background colors, borders, shading, fonts style that match certain given conditions. Conditional Formatting allows you to apply different kind of formatting on selected range of cells in active sheet.
Conditional formatting allows you to quickly apply alternate color shading between rows in Excel.ĭuring working on active worksheet you can use Conditional Formatting feature to decorate the sheet. If you do this job manually then it will take lot of time. All Rights Reserved.Sometime we you are working on large worksheet you need to automatically apply alternate color shading between rows in Excel. In Condition 1 type the following formula "=MOD(COLUMN()-2,4*2)+14". In this example we want to shade the columns in blocks of 4. You can use a similar method to the one above to apply automatic shading to bands of columns. In Condition 1 type the following formula "=MOD(ROW()-2,3*2)+13". In this example we want to shade the rows in blocks of 3. You can use a similar method to the one above to apply automatic shading to bands of rows. In Condition 2 type the following formula "=MOD(COLUMN(),2)=1". In Condition 1 type the following formula "=MOD(COLUMN(),2)=0". You can use an identical method to the one above to apply automatic shading to your columns as well. This formula is True for any cells that have odd row numbers. In Condition 2 type a similar formula "=MOD(ROW(),2)=1". This formula is True for any cells that have even row numbers.
EXCEL FOR MAC ALTERNATE ROW COLOR MOD
The ROW function returns the row number of the current cell and then the MOD function is used to obtain the remainder after dividing this number by 2. In Condition 1 type the following formula "=MOD(ROW(),2)=0". You can use formulas to determine the outcome and depending on the formula used it does not even have to contain any cell references. Select the cells you want to shade and select (Format > Conditional Formatting).įor more information about Conditional Formatting, please refer to the Conditional Formatting section. If you find that your data moves around a lot and you would like to apply automatic alternate shading to a range of cells then this is possible using Conditional Formatting.
0 kommentar(er)
