Conditional Formatting and Sorting a Table
Open the table created previously (inventory level Priority) Add conditional formatting to the priority field using the Icon sets format style and the 5 ratings icon style. Complete the following three sorts A)sort the table in ascending sequence (smallest to largest) B) sort the table by amount (ascending within priority code (descending) and c) sort the table in descening sequence by priority code. With the table sorted by priorty toggle off the total row, concer the table to a range and then use the subtotal button on the data tab on the Ribbon to determine subtotals for each priority code.