which cell contains conditional formatting in Excel
Q45. In Excel, how do I know which cells on the worksheet contain Conditional Formatting?
To do it in Excel, here is the answer:
a) Under "Home" tab, click on "Find & Select" -> "Go To Special".
b) Select "Conditional Formats" option and then click OK.
c) Cells with Conditional Formatting will be selected as shown below.