by Nate Moore | May 3, 2010 | Conditional Formatting
Excel Video 54 is a straight-forward demonstration of how the Top or Bottom Rules work in Conditional Formatting. It’s easy to format the highest or the lowest items in a list, or with one click, you can highlight the highest or lowest percentage of values in a list....
by Nate Moore | Apr 28, 2010 | Conditional Formatting
Excel Video 53 shows an easy way to format all blank cells or error cells in part or all of your spreadsheet. If you have a spreadsheet with a lot of data or a lot of calculations, it’s very helpful to highlight cells with potential problems. The other thing I...
by Nate Moore | Apr 26, 2010 | Conditional Formatting
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...
by Nate Moore | Apr 21, 2010 | Conditional Formatting
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...
by Nate Moore | Apr 19, 2010 | Conditional Formatting
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...
by Nate Moore | Apr 14, 2010 | Conditional Formatting
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...
