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