Excel - How to find cells having Conditional Formatting

In my last excel tutorial we have seen how to use Conditional Formatting feature with some examples. Now in this one we are going to talk about how to find worksheets/ cells that are already having Conditional Formatting. For various reason, we may want to know if an excel worksheet or a range of cells having already defined Conditional Formatting. We may want to apply some basic formatting, want to add new Conditional Formatting or modify existing Conditional Formatting.

One option is to use ‘Find & Select’ option another is to use ‘Manage Rule’ option from Conditional Formatting drop down. Check out the video tutorial for details of these two options.