Select Page

Excel Video 60 Stop if True

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

Excel Video 59 Manage Conflicting Rules

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

Excel Video 58 Manage Rules

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

Excel Video 55 Above or Below Average

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