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, ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.