![]() ![]() To create this color banding, you will need to select the cell range you are targeting and add a new Conditional Formatting rule. Note, if you insert a row inside your currently formatted rows, the conditional formatting rule will automatically adjust to include it. Explore the Conditional Formatting Rules Manager dialog. Apply a second conditional formatting rule to the same set of cells. If you are using the example, apply formatting to all of the sales data. ![]() This means if you add a new row to the bottom of the table at a later date, you will need to update the conditional formatting data range to ensure the new row is included in the rule. Apply conditional formatting to a range of cells with numerical values. The only disadvantage to this method is (as of this writing) we cannot reference named ranges in conditional formatting rules. If you don’t want to utilize an Excel table, you can alternatively utilize conditional formatting rules to get alternating colors.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |