WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 519 reviews for our classroom and online training
Answer to (and winner of) our March 2022 competition
Last month's competition invited you to decrypt a message encoded in Excel coloured cells - this blog gives the answer and winner!

Posted by Andy Brown on 30 March 2022

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Answer to (and winner of) our March 2022 competition

Last month we asked you to decipher this message:

The colourful message

The RGB colours for each cell yield an encrypted message.

One way to solve this is with a macro written in VBA.  You can see not only a solution but also the code to set the puzzle in this workbook:

Decryption macros

The decryption macros are in the first module.

 

Here's the final message this reveals: 

Final message

The final message is (as a bit of Googling would reveal if you haven't read it) a quote from 1984, by George Orwell.

Congratulations to Mike Nicholson of IBM, who wins this month's £50 Amazon voucher (his was the first entry out of 16 received picked out of our randomised sorting hat).

This blog has 0 threads Add post