Select Page

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 with constants, cells with comments, etc.
Once you’ve found conditionally formatted cells, it’s easy to clear conditional formatting, either from selected cells, from the whole sheet, from a table or from a Pivot Table. Stay tuned. Next time we’ll walk start a discussion on how to manage multiple conditional formats for the same cell.