Click Data > Filter, Excel will add drop-down arrows to the column headers.ħ. Finished the above steps, now you need to filter the date. And the range which you select has been shaded alternately.Ħ. And click OK, it will return to the New Formatting Rule, and now you can see the color in the Preview box. Then click Format button, and a Format Cells dialog box will pop out. And click the last option Use a formula to determine which cells to format in Select a Rule Type, and enter this formula “ =MOD(SUBTOTAL(3,$A$1:$A2),2)” into the box.Ĥ. Then click Home > Conditional Formatting > New Rule, and a New Formatting Rule dialog box will appear.ģ. In this example, we will select the range (A2:G25).Ģ. If filtering is already in play, be sure to remove the filter to select the full range. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!īy doing this, you should do with two major steps:Ī: Shade the range alternately (step1-step5)ī: Filter the data you need, the shading will automatically change (step6-step9)ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |