find cells with conditional formating worksheet in Excel

Q102. In Excel, how can I identify all cells with Conditional Formatting in my WorkSheet?

Note: This would be very helpful if you have inherited a complex WorkSheet and want to understand how the WorkSheet has been set up.

For example, in the table below, I would like to quickly identify the cells that have conditional formatting.

excel find cells with conditional formatting worksheet

To do it in Excel, here is the answer:

a) Press F5 and in the "Go To" dialog that pops up, click on "Special" (Alternatively, click on "Find & Select" under "Home". Click on "Go To Special").

excel excel find cells with conditional formatting worksheet

b) In the "Go To Special" dialog box, click on "Formulas", click OK.

excel excel excel find cells with conditional formatting worksheet

c) All the cells with "Conditional Formatting" are selected / highlighted as shown below.

excel excel excel excel find cells with conditional formatting worksheet


You can find similar Excel Questions and Answer hereunder

1) How can I insert a watermark in my Worksheet?

2) How can I hide a specific Shape in my WorkSheet?

3) How can I remove Outline from my WorkSheet?

4) Find and count instances of a character in a string in Excel

5) How can I add a background image to a worksheet?

6) How can I hide all comments in my WorkSheet using VBA?

7) How can I remove hyperlinks from a range of cells?

8) How can I quickly remove all blank cells in a data range?

9) How can I loop through all WorkSheets and get their names using VBA?

10) Is there a way to create an visually impactful report with stop lights indicating automatically if Target is met?

11) How can I sort data using multiple criteria?

12) How do I add a symbol like Triangle / Inverted Triangle for indicating trends in a cell using VBA?

13) I have a complex WorkSheet with lot of fields and data - How can I quickly find the cells that have formulas?

14) How can I protect / unprotect WorkSheet using VBA?

15) How can I identify the cells that influence a particular cell to help with debugging of my spreadSheet or understand a spreadSheet that I inherited?