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...
by Nate Moore | Mar 29, 2010 | Conditional Formatting
Welcome to the next set of Excel Videos. We’ve covered Pivot Tables and Tables in Excel 2007 in depth. Excel Video 44 begins a new series on Conditional Formatting. Conditional Formatting is an Excel tool that allows you to set up a variety of rules or criteria for a...
