USING THE PIVOT TABLE DATA I CAN EMAIL THE EXCEL SHEET TO USE

Worksheet 1 (Conditional Formatting-Sorting)

1.Conditionally format the bottom 10% of the sales units.(2 salespeople).

2.Sort based on these bottom 10% at the 'top'

Worksheet 2 (Cell Attribute-Filter)

1.Conditionally format the sales units that are greater than 1000.(5 salespeople).

2.Filter by the format that you applied in #1.

Worksheet 3 (Number-Filter)

1.Conditionally format the sales units by the 'top 10 items'. (10 salespeople)

.

2.Filter by the top 5 items.