Excel Xmas Tree Decorator (No VBA) — A Tiny Game You Can Share With Colleagues

Want something festive, quick, and surprisingly useful to show what Excel can do beyond tables? This little Xmas Tree Decorator is a macro-free Excel mini-game built only with native features like dropdown lists, icons/emojis, conditional formatting, and formulas.

It’s perfect as a fun office share, an Excel training warm-up, or a creative example for what’s possible with “just Excel”. 🎄🎄🎄

---

Would you like to download this Xmas fun tool for free? Click here.

Join newsletter

---

What it does

• You get a pixel-style Xmas tree (a grid of green cells).

• Every green cell has a dropdown so you can pick ornaments (⭐🎁❄ etc.).

• A simple scoreboard can count ornaments and calculate points.

• Optional bonus: a “Snow Forecast” that reshuffles with F9.

Interactive Xmas Tree Decorator: Customize your tree with ornaments and match the snow forecast to score points, unlock achievements, and share your festive creation!

1) Build the Tree Grid

1. Create a sheet called TREE_GAME.

2. Set cells to a square look (for a pixel style):

   • Column width ~ 2–3

   • Row height ~ 18–22

3. Pick an area like B6:N25 (or any size you want).

4. Color the tree area (the “playable” cells) green and keep the background white.
   

2) Create the Ornament List (Dropdown Source)

1. Create a second sheet called HELP.

2. Add a list of ornaments in one column (example):

   • ⭐ 🎁 🔴 🔵 🟡 ❄ 🧸 🍬 ✨ (anything you like)

3. (Optional) In the next column store points per ornament, e.g.:

   • ⭐ = 5, 🎁 = 10, ❄ = 2, etc.

4. Select the ornament list and make it a Named Range:

   • Formulas → Name Manager → New → Name it OrnList

Game Ornament Guide: A table listing different ornaments with their points, UNICHAR codes, and usage tips, alongside a function playground that showcases formulas for calculating points and achievements in the game.

3) Add Dropdowns to the Tree Cells

1. Select the green tree cells (only the playable area).

2. Data → Data Validation → Allow: List

3. Source: =OrnList

4. Enable:

   • ✅ In-cell dropdown

   • ✅ Ignore blank (optional)

Now every tree cell lets you pick ornaments via dropdown.

4) Make it “Game-Like” with Conditional Formatting

Add rules to make the tree feel alive:

• Highlight certain symbols (e.g., ❄ turns light blue, ⭐ turns gold)

• Add a rule that colors empty tree cells a lighter green

• Add a “WIN” message when score hits a target

(Conditional Formatting → “Format only cells that contain” → Specific text)

5) Add Scoring (Simple, Fun, and Extendable)

On TREE_GAME, count symbols and multiply by points. Two common options:

Option A: COUNTIF-based

• =COUNTIF(TreeRange,"⭐")*5 + COUNTIF(TreeRange,"🎁")*10 + ...

Option B: Lookup-based (cleaner)

• Create a small points table on HELP (Ornament | Points)

• Use XLOOKUP() or VLOOKUP() in a helper grid to convert each ornament to points

• Sum the helper grid for total score

Scoreboard from a festive decoration game showing points for a "Top Star" and highlighting unlocked achievements. Keep aiming for more decorations and bonuses!

6) Bonus Feature (Optional): “Snow Forecast”

Add a tiny “forecast” grid that randomly suggests where ❄ should be placed:

• Use RANDBETWEEN() to generate 0/1 values

• Bonus points if the user matches ❄ on those positions

• Press F9 to reshuffle

---

This will be the last post for 2025. Thanks for your support, interest and shares. I wish you all the best! See you in 2026!

---

If you found this guide useful, explore the related posts below or download a free Power Query cheat sheet by subscribing to the Excelized newsletter.

👉 Want to learn this hands-on? Book a live 1:1 Excel Basic Course and go from raw data to confident reporting.

---

Learn with your own examples

Explore private Excel training and discuss the formulas and small projects you want to build.

Explore Excel training