Excel Video 51 demonstrates more ways to use Icon Sets in Conditional Formatting. In this example, I have results from a patient satisfaction survey that I want to convey powerfully and concisely. Rather than just show the numerical results from 1 to 5, I’ve shown the results in what Excel calls Quarters, full, 3/4, 1/2, 1/4, and empty. By displaying the data this way and hiding the numbers, I can display a lot of data in a confined space. If you’re looking for a way to put more data on a one-page report, try only showing the icons instead of the numbers.
We’ll also spend more time in this video showing you how to customize the defaults that Excel uses for icons. There’s a lot of flexibility when it comes to conditional formatting. Stay tuned next time and we’ll walk through more customization options.