Imagine you have some data showing performance of some teams in different categories:
A very quick way of showing the results more visually is to create a thermal map. You can do this very quickly using conditional formatting! Download the sample excel sheet here.
- First, highlight the values in the first column (result 1)
- Then on the Home tab, click on the small arrow next to the Conditional Formatting button (in the Styles section)
- Click on Color scales and then More Rules
- Ensure that “Format all cells based on their values is selected
- Then in the Edit the Rule description section, choose a 2-color scale and choose 2 colors. I’ve left the default colors in place for the first column (orange and light orange)
- When you are done, press the OK button. The column should automatically update
- You can then repeat this for each of the other columns, using different…
View original post 82 more words