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?

2 replies

by zimonar

Excel provides over 225 built in functions. Please, can you tell me what kind of function I should use to select only the cells with Conditional Formats/to select only the cells with Data Validation in my huge data without selecting the whole data? Thank you!

This discussion is closed to new replies.