Find all Conditional Formatting on a Worksheet


Ever try to find conditional formats on a worksheet when the worksheet is showing all cells with unformatted appearance? It’s guaranteed to drive you bonkers and waste your time.

Here’s how to do it VERY quickly. Use the Go To Special command. Press F5 or Ctrl+G to display the Go To Special dialog box. Click the Special button, then select the Conditional Formatting option and choose Ok.

Cells or ranges formatted with conditional formatting are selected. Move between selected cells while keeping them selected by pressing the Tab or Shift+Tab key.