General discussion

Locked

Excel.

By zimonar ·
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?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by dabrat_04clik In reply to Excel.

You must use a functions to do this.

Collapse -

by zimonar In reply to

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!

Back to Windows Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums