Excel Files with Temperature Charts and Conditional Formatting

I am reposting links to some files for tracking temperatures. The files are in Excel, and there are several sheets available within each file to choose from. What you choose depends on where you live and the temperature range there, and how many colors you would like to use for your project.

• 2018TemperatureChart-Celsius-1.xlsx (22378 downloads )
• 2018TemperatureChart1.xlsx (20719 downloads )

I have one for Fahrenheit and one for Celsius. Each chart makes some general color suggestions, like red-violet, red, red-orange, orange, yellow-orange, etc.

However, I want to point out that there is no right or wrong way to do this. You may opt to have various shades of only blues and purples in your temperature blanket. But I will point out that common color theory places some colors in the “cool” category and others in a “warm” category – so it makes the most sense to keep your warm colors with the warm temperatures and the cool colors with the cooler temperatures. That being said, it is YOUR blanket and it is totally up to you. Here is an example chart that I was considering, since I like cool colors more than warm colors: