Question 1

Using the “Data Set”, write a macro to highlight every sale with total revenue greater than $2000. Your macro should highlight in yellow the columns from Name to Total revenue but not highlight any columns after total revenue. The macro must detect when the names in the table have a blank and stop functioning at this point.

Paste the macro code here:

Question 2

Write a macro that does the following:

·         In cell “K1” in the file “Data Set” enter and bold the title “combined Customer and Product Rating.” You can use “hard” references to code this in.

·         Enters in the product of (i.e., multiply) the customer and product rating in each cell in column K if the product of the customer and product rating is greater than or equal to 3, if it is less than three it should enter the word “BAD.”

·         For all sales that have a combined rating of “BAD” in column K, the macro should highlight in yellow the product and/or satisfaction ratings contributing to that rating that are less than 3.

·         The macro should automatically stop when there are blanks in both the customer and product satisfaction columns.

Data Set.xlsx
大小:(303.05 KB)

 马上下载