Find cells with conditional formatting worksheet in Excel
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.
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").
b) In the "Go To Special" dialog box, click on "Formulas", click OK.
c) All the cells with "Conditional Formatting" are selected / highlighted as shown below.
You can find similar Excel Questions and Answer hereunder
1) What are worksheets events in VBA. Here we explain some of the main one like like activate or deactivate
2) How can I add a WorkSheet and name it as required using VBA?
3) What are the various functions of the worksheet in Excel VBA
4) How to lock cells so that no one can change them
5) How can I save a WorkSheet as a new WorkBook using VBA?
6) Conditional formatting with if statement in Excel
7) Given a raw data Table, how can I find the value of a field for a specific value of another field?
8) How can I remove hyperlinks from a range of cells?
9) How can I remove Outline from my WorkSheet?
10) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?