I went all out on this one - probably because I wanted to determine the cities with Red or Purple levels. I made this into an app that will allow the user to select both city and month. As I expected California had some Red levels, but unexpectedly Camden, NJ even had some purple!
I went a little overboard with this one. I decided that I wanted a coloured preformatted table in Excel for each State-County-City combination split into an Excel file for each State with each County-City in a different Excel sheet. So I used a couple of batch macros (my favourite) to produce the coloured tables and then output these into their corresponding Excel file/sheet.