To do so, check Total Row in the Table Styles Options group on the contextual Design tab, as shown in Figure B. For that purpose, let's add a totaling row to the bottom of the Table. SEE: Securing Windows policy (Tech Pro Research) Add Total rowĪs is, we can filter by color-but now we need a way to evaluate the values visible after applying a color filter. At this point, we have a Table, and the invoice values have a conditional format. In the resulting dialog, check the My Table Has Headers option and click OK. Then, click the Insert tab and then click Table in the Tables group. To do so, click anywhere inside the data. For that reason, we'll convert the data range to a Table. What you might not know is that the ability to sort a Table by color is built in. The data set now has several colors, but as is, they're not much help for counting or totaling the invoice values. A conditional scale set applies different colors to the invoice values in column B.
