We are creating a new customer classification system to focus on our largest customers. Our biggest customers are going to be called “Gold” class customers and the next group will be called “Silver” class customers:
“Gold” class customers are those whose average monthly sales for the last twelve months are $7,000 and greater or the average previous quarter sales are $7,000 and greater.
“Silver” class customers are those whose average monthly sales for the last twelve months are between $2,000 and $7,000 or the average previous quarter sales are between $2,000 and $7,000.
Add a column next to the average monthly sales on the AR Aging sheet called “class” and make the word “Gold”, “Silver”, or blank appear as explained above. HINT: Do not try to do this step with Conditional Formatting.
Now format these three columns: (1) Customer #, (2) the Customer Name, and (3) Class. Format all of these columns with gold fill and white font for the "Gold" class customers, and silver fill and white font for the “Silver” class customers.
On the aging report, add our company’s logo (your choice of an appropriate logo), put a useful title on the report, add a freeze pane, and follow all Standards of Professionalism (only for the AR Aging report). The Standards of Professionalism are described in this list . You can also review this video tutorial to watch an explanation of the Standards of Professionalism.
Solved by B. D. in 12 mins