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...
by Nate Moore | Apr 12, 2010 | Conditional Formatting
Excel Video 48 covers a Conditional Formatting tool called Data Bars. Data Bars are simply a way to format the background of the cell with a fill color based on how high or low the data in the cell is. Excel offers 6 one-click pre-formatted Data Bars to choose from...
by Nate Moore | Apr 7, 2010 | Conditional Formatting
Excel Video 47 reviews the three sets of Top/Bottom Rules, Top/Bottom x Items, Top/Bottom x Percent, and Above/Below Average. The first thing to note is that even though Excel labels the rules Top 10 Items, etc., you can easily change to find the top or bottom item, 5...
by Nate Moore | Apr 5, 2010 | Conditional Formatting
Excel Video 46 describes how to highlight specific dates and how to find duplicate values using conditional formatting. If you have a list of dates, it’s easy to highlight dates meeting a variety of criteria, such as yesterday/today/tomorrow, last week/this week/next...
by Nate Moore | Mar 31, 2010 | Conditional Formatting
Excel Video 45 starts at the top of the Conditional Formatting menu with the Highlight Cells Rules. Highlight Cells Rules do exactly that, they highlight or conditionally format cells that meet certain criteria. Excel Video 45 shows several examples, both with numbers...