Skip to content

Email Newsletter Challenge 3

This week’s challenge will test your ability to perform a not so common task. The solution is simple, but will you find it to be easy?

Whether you prefer Excel or Google Sheets, you can download the spreadsheet challenge using the links below.

The Challenge

This week, your task is to create a heat map that displays the highest sales numbers in green and the lowest sales numbers in red.

Think you can solve this one? Download the spreadsheet file using the link above and give it a try.

The Solution

The solution to this problem is actually quite simple – if you know where to look.

That’s the tricky part, knowing what to do and where to look.

To create a heat map, you will have to create a color scale use Conditional Formatting. Since the menus for Excel and Google Sheets are a little different, here is the full explanation for each program.

EXCEL

Select the data (C7:J10).

Go to Home > Conditional Formatting > Color Scales > Green – White – Red Color Scale.

And that’s it. You now have your heatmap.

GOOGLE SHEETS

Select the data (C7:J10).

Go to Format > Conditional Formatting.

In the panel on the right, select Color Scale.

Under preview, select the Red to White to Green option. Then click on Done.

And that’s it. You now have your heatmap.

As you can see, the solution isn’t that complicated. Rather, it’s one of those things that is easy if you know where to look and what to do. But if not, solving a question like this may be difficult.

Luckily, that’s not the case for you any more. You’ve got it now!

Also, if you want to learn more about conditional formatting and really get the hang of it in Excel, I highly encourage you to sign up for the Excel Launchpad course. This is the best course you can take for nailing the fundamentals of Excel and getting this amazing skill onto your resumé.

And, if you’re not signed up for my weekly email newsletter, you can sign up right here!

This Post Has 2 Comments

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top