In Excel, how to find only cells with identical conditional formats? I click the specific formatting cell and check the ?Same? box in Edit, Go To Special dialog box. This option selects the whole data, like ?All?. It should select only cells with identical conditional formats! Why? Is that because I should select the data to use the Conditional formats and Data validation? My data is enormous, how to find in, only cells with identical conditional formats?