Clown catapult

You've kidnapped clowns to use as ammunition for your clownapult.


Write a program that will scan through clown data, and identify clowns that meet the user's criteria.

Here's a sample:


The user types in criteria for weight and shoe size, and clicks Run. The program highlights clowns that meet the criteria by setting the background color of their id and name cells to yellow. Clowns that do not meet the criteria are set to white. Clowns must meet all criteria to be selected.

Assume that the user makes no mistakes when typing in the data. Assume there are no errors in the clown data.

The program also shows some statistics. The overall clown count is the total number of clowns in the data set. You don't need to round the averages.

Here's another example:


A clown that was marked in yellow for one run, might be marked in white the next time. So, you need to explicitly set the cell color for each clown to yellow or white.

If no clowns meet the criteria, you won't able to calculate the average. In that case, show messages instead:

No data

Don't start from scratch. Download and use the starting workbook that has been created for you.

The usual coding standards apply.

Hint: Declare variables for totaling as Longs, rather than Integers. The starting workbook has those declarations for you.

Upload your solution.

(If you were logged in as a student, you could submit an exercise solution, and get some feedback.)

Referenced in: