Discussion Locked
Excel.
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?