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...
by Nate Moore | May 3, 2010 | Conditional Formatting
Excel Video 54 is a straight-forward demonstration of how the Top or Bottom Rules work in Conditional Formatting. It’s easy to format the highest or the lowest items in a list, or with one click, you can highlight the highest or lowest percentage of values in a list....
