Holiday Weekend Flags in Excel

Happy Canada Day! I made this Canadian flag in Excel, to help you celebrate. If you don’t examine it too closely, it looks pretty good – a maple leaf is hard to draw in Excel.

Flags02

You can also select USA from the drop down list on the worksheet, if you’re celebrating the 4th of July on Monday.

Flags01

How the Flags Work

There are two sheets with flags, and a named range on each sheet. In the screenshot below, you can see the FlagUSA named range. Its name is visible on the worksheet, because the zoom is below 40%.

Flags05

There is also an Admin sheet, with a named range for Countries, the selected country (linked from the combo box), and the number for the selected country.

Flags03

The cells on the Flag sheet have an array formula, that links to the cells on the selected country’s sheet. The CHOOSE function determines which named range to use.

Flags04

Each coloured cell on the country sheets is numbered, and conditional formatting shows the applicable colours on the Flag sheet.

Flags06

Download the Holiday Weekend Flags Workbook

To see how the flag file works, you can download the Holiday Weekend Flags workbook. This file is a bit big, at 154 KB, and it is in Excel 2007 format, and zipped. There are no macros in the file.

__________

You may also like...

4 Responses

  1. They don’t wave? Next year, I’d like to see some flags that wave. Better yet, have a drop-down with these waving options: No Wind, Slight Breeze, Occasional Gusts, Strong Wind, Hurricane. Use macros if you must.

    Thanks.

  2. Thanks John, great feedback! I’ll pass that along to the development team.

  3. John Marshall says:

    I can save you some time by doing the hurricane one for you.

    It is just a blank screen (the flagpole broke)

    In other words, you did a good job and I am jealous. ;-)

  4. Thanks John, good idea for the hurricane version.

Leave a Reply to John Walkenbach Cancel reply

Your email address will not be published. Required fields are marked *