It is Easter time. This is the first Easter we are celebrating in our new house. So it is bound to have so many special memories. For last 10 years (wow, it has been a decade of tradition), I have been running Excel based egg hunts every Easter. It all started in 2009, when I was living in Sweden (where Easter is a BIG thing). I had to share the enthusiasm with someone, so I made our first Easter egg hunt on the blog.
This year, let’s take it up a notch. I have started doing cryptic crosswords around new year and now it is part of my daily routine. I do a puzzle from either The Hindu or from one of the crossword books. Sometimes they are easy, sometimes I stare at a clue for several minutes and doze off.
So let me share the joy of solving cryptic clues with you. As I am pretty rubbish at this, so I couldn’t really create a grid, Instead I just wrote some clues in an Excel workbook, linked answers to conditional formatting so when you type the correct answer the cell lights up. Of course the answers are encrypted, so you will have to figure them out the usual way (rather than hacking in to the formulas).
Click here to download Easter Eggs – Crossword clues.
How many could you solve? Post your tries and answer counts in comments. Also explain how you arrived at the answer.
Want more eggs? Check out previous Easter egg hunts
Go thru previous year hunts. Be warned though, they are highly addictive.
2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010 & 2009
and of course, Play hidden Angry Formulas game in Excel too
19 Responses
Hi Chandoo,
The conditional formatting doesn’t seem to be working for me, there’s a few I can get and the rest I got through encryption answers provided, though I couldn’t find a decryption code or method so just had to use vlookup to help fill in using the encryption tables after getting the first answer…
Thanks David. Sorry for the trouble. Can you download the file again please? I have fixed the compatibility issue now.
Cryptics are great … never seem to be able to find enough of them, and generally keep a copy, as I usually go back to unfinished ones from time to time. Was introduced to them in Games Magazine.
Now excel-related to your cryptic topic … here is a link to an old 2010 blog article and Excel template from Dick Kusleika to build a crossword grid:
https://goo.gl/M8LPPy
Hi all, My original file was built to work with Excel 2013 and above only. I have now uploaded another version that can work with older versions too (should work all the way back to 2003, but haven’t tested). Try it out.
Got 1, 2, 3, 9, 14, 16 and 19. Am lost on the rest. Thanks for v1 – the original conditional formatting didn’t work and I was sure I had some right!
“Did you click the wrong link”… Yes I did. Nice trick. haha.
Happy April Fool.
Classical. And he does that every year… Still it works every single time 🙂 Didn’t fool me this time.
The assignment is way too cryptic for me to understand. More then lost in translation.
Honestly, I have NO idea how to do it at all… 😛
Finally got 2,3 and 14 by actually understanding the phrases.
Found the enigma wise translation table in answers, but it ain’t allowing me to collect the sweet chocolate eggs. So frustrating.
A typical Chandoo game thus.
@all..
Seeing that we have so few responses so far, I have uploaded v2 with option to switch to easier clues or normal crossword clues. Give it a go, Spend your Easter day on this low calorie egg hunt instead.
My mind can’t think through the clues. I am good at reverse engineering formulas though and forcing workbooks to show me their answers. 🙂
Your are a ninja, so that does not count! 😉
I have no clue whatsoever how to start on the reversed engineering.
macro
ribbon
power query
bahttext
sumproduct
vlookup
scatter plot
randbetween
remove duplicates
alt est
freeze panes
comment
conditional formatting
value field
lotus
excel
pivot tables
solver
still to figure out #12/18
Hi ,
What word can you associate with butter ?
Use that word with THESE and re-arrange.
Hey prashant, here’s a crazy idea: How about you don’t post the answers in the comments in case other people are still working through the questions.
Hey Black Moses, here’s a crazy idea: How about you ease up a little on Prashant, as he/she was simply following the suggestion listed in the body of the original post…. “How many could you solve? Post your tries and answer counts in comments. Also explain how you arrived at the answer.”
I realize that the publisher only requests that we post our “tries” and “answer counts”, but also requests that we “also explain how you arrived at the answer”, which basically is the same as typing the answer.
If you get this upset over an online excel-based holiday game, then maybe this type of thing isn’t for you.
That being said……. Have a great day!
New user here who happened to stumble on this very fun puzzle by coincidence. From the normal clues I was thinking for number 18 worksheets, which is a character too short, but with the cryptic clues I found what it had to be instead of that.
12 – Slicer
This is so much fun!Truly felt like an easter egg hunt!
Thanks for the puzzle chandoo!And also, I love the colors of the eggs in the picture you have posted.
got all greens except No.3, still working on