by Nate Moore | May 24, 2010 | Conditional Formatting
Excel Video 60 wraps up our discussion of Conditional Formatting with a discussion of the Stop If True box in the Conditional Formatting Rules Manager. The Stop If True box was included in Excel 2007 to support compatibility with prior versions of Excel. Older...
by Nate Moore | May 19, 2010 | Conditional Formatting
Excel Video 59 continues our review of what Excel does when multiple Conditional Formatting rules are applied to the same cell or range of cells. Excel has a Conditional Formatting Rules Manager window that shows all of the conditional formats applied to a given cell...
by Nate Moore | May 17, 2010 | Conditional Formatting
Excel Video 58 introduces the idea of multiple conditional formatting rules applied to the same range of cells. For example, the video highlights a range of cells using color scales and then wants to bold the highest cell value in the range. Excel Video 58 introduces...
by Nate Moore | May 12, 2010 | Conditional Formatting
Excel Video 57 is a short, easy discussion on how to find conditionally formatted cells and how to clear conditional formatting from cells. The find menu will help you find conditionally formatted cells. The find menu will also help you find cells with formulas, cells...
by Nate Moore | May 10, 2010 | Conditional Formatting
Excel Video 56 shows how to conditionally format cells based on a formula. If the formula is true, Excel formats the cell. To understand the example, you need to understand how the OR function and the WEEKDAY function work. The OR function returns true if any of the...
by Nate Moore | May 5, 2010 | Conditional Formatting
Watch Excel Video 55 to learn how to conditionally format cells that are above or below the average of the cells in your range. There’s also an option to format cells that are 1, 2 or 3 standard deviations above or below the average. Please watch carefully and tell me...
