Overview
A fun, formula-driven Christmas Tree built entirely in Excel using conditional formatting, Unicode star characters, and VBA macros. Press F9 to randomise the ornaments, lights, and presents — each recalculation generates a unique tree with different decorations. Includes 11 embedded images and a festive greeting message.
Download the Excel file (.xlsm)
How It Works
- Tree Shape: A data table with MOD calculations creates the triangular tree silhouette using conditional formatting to fill cells green.
- Star Ornaments: A lookup table of 25+ Unicode star characters (★ ☆ ✵ ✶ ✷ ❉ ⭐ 🌟 💫 ✨ and more) are randomly placed on the tree with each recalculation.
- Light Switch: Toggle lights on/off via an auto switch control.
- Sugar Canes & Presents: Additional decorative elements positioned around the base of the tree.
- Seasonal Message: Displays "Merry Christmas & Happy New Year! Wishing you joy, health, and success throughout the seasons!"
Technical Details
- Auto Text Switch: Toggles between displaying ornament characters and hiding them.
- Auto General Switch: Controls the overall visibility and animation state.
- LU_Stars: A named range lookup table containing all the Unicode star/ornament characters for random selection.
When to Use This
A perfect example of creative Excel usage and a great conversation starter for the holiday season. It demonstrates how conditional formatting, MOD arithmetic, RANDBETWEEN, and Unicode characters can create surprisingly visual results from a spreadsheet. Also makes a memorable team gift or holiday email attachment!