To achieve the above effect you use this formula: You can use a slight variation of the above formula to shade multiple rows like this: Click the Format button and from the Format Cells dialog box select the Fill tab > choose your weapon (colour, pattern, fill effect etc.):Ĭonditional Formatting - Shade multiple rows. Select 'Use a formula to determine which cells to format' > enter your formula in the 'Edit the Rule Description' field.įor alternating bands your formula is =MOD(ROW(),2).On the Home tab of ribbon select Conditional Formatting > New Rule.To create this effect we need to create a new rule which uses a formula to determine which cells to format. It's ok, no zebras get hurt in this process, it's actually all built in to Excel's Conditional Formatting □ Conditional Formatting - Shade Alternate Rows Excel for Decision Making Under Uncertainty Course.Excel for Customer Service Professionals.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |