Excel® 2013 On Demand

Finding Conditional Formatting

If you have cells in your workbook that contain conditional formatting, you can quickly find them using the Find & Select button in order to change, copy or delete the formatting. You can use the Conditional Formatting command to find all cells that have a conditional format, or use the Go To Special command to find only cells that have the same conditional format.

Find Cells with Conditional Formatting

Select any cell with or without a conditional format.

Click the Home tab.

Click the Find & Select button arrow, ...