Select Page

Excel Video 52 Format Based on Values

Excel Video 52 continues our discussion of Conditional Formatting. We’ve been through each of the major Conditional Formatting categories in prior videos. Starting with Excel Video 52, we’ll now go through the six Rule Types in the New Formatting Rule window. Many of...

Excel Video 51 Icon Sets, Part 2

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...

Excel Video 50 Icon Sets, Part 1

Watch Excel 50 to learn how to use a variety of Excel’s icon sets in conditional formatting. Icon sets can be especially useful as you try to set up dashboards and other summary reports so readers can quickly focus on key practice indicators. This example walks...

Excel Video 49 Color Scales

Excel Video 49 introduces Color Scales, another Conditional Formatting tool I think you’ll find useful. Color Scales blend either two or three colors in a cell’s background to better highlight the data in the cell. In the example in Excel Video 49, the cell’s...