Conditional formatting; Format Painter, Auto Filte

 Which are the large 50000) and very large 500000 donors in the DC region, who are also insect enthusiasts?
Features:  Conditional formatting; Format Painter, Auto Filter
Instructions:  Click on the first cell in the giving column containing an amount (E2) and select Home, Styles, Conditional formatting.  Choose Highlight Cell Rules, Between…, and indicate that the cell value is between 49999 and 499999 and choose a color for display.  Then click OK.  Use the same process to indicate that if the cell value is greater than or equal to 500000, and choose a different color for this display.
Now, copy (paint) this format to the remaining cells in the column.  Click on the cell you have just formatted (E2) and click on the Format Painter icon—the small paintbrush located in Home, Clipboard. When the paintbrush is active, click on the first cell in your format range (E2) and drag your cursor to the end of the format range (E326).  The cells with values meeting the criteria should have changed color.
Now you can use Auto Filter to view selected records.  Click on a cell containing data and select Data, Sort & Filter, Auto Filter.  To practice using Auto Filter, click on the pull-down menu in the in the Giving column and select Top 10 (under Number Filter).  Change the selection to 20 and press return.  The remaining records are the top 20 largest donors.
Now return to your original view by clicking on the Giving pull-down menu again, and placing a checkmark in (Select All).  Now click on the pull down menu next to Location and select DC Region.  By scrolling down, you can see all donors in the DC region only.
Now return to the Giving column and select Number Filters, Custom Filter.  Indicate that you wish to see records for which the cell value is greater than or equal to 50000.  Now imagine that you’re going to have an invitation-only party of insect enthusiasts in the DC area.  Use the Interests pull-down to find donors interested in Insects.
Select all and copy to your Word doc. on one page showing the answers to the question - only Insect Lovers in the DC Region donating $50,000 or more.  Don't worry if you don't have a color printer.  It'll show up shaded.