Advanced Criteria-Based Cell Selection...

This tool lets you quickly select cells in Excel using advanced criteria that go far beyond Excel's built-in filtering options.
It offers a wide range of criteria that allow you to select cells based on their content, formatting, properties, date, or anything else you can think of.
For example, you can select cells with bold formatting or dates from a specific month or quarter, though the tool offers much more flexibility than these examples.

Select cells by their content based on any of the following criteria:

• between
• not between
• equal to
• not equal to
• greater than
• less than
• greater than or equal to
• less than or equal to
• begins with
• does not begin with
• ends with
• does not end with
• contains
• does not contain
• like (text, with use of wildcard characters)
• not like (text, with use of wildcard characters)
• duplicate values
• unique values
• empty cells
• not empty cells
• FALSE
• TRUE
• text length
• values in lowercase
• values in UPPERCASE
• odd numbers
• even numbers
• number (constant)
• number (formula)
• number (link to sheet)
• number (link to file)
• formula with reference to file
• formula with reference to sheet
• contains any of the values specified in a range
• contains any of the full words specified in a range
• does not contain any of the values specified in a range
• does not contain any of the full words specified in a range
• equals a value specified in a range
• does not equal a value specified in a range
• contains all values specified in a range
• contains all full words specified in a range
• matches regular expression

Select cells by their formatting or other properties based on any of the following criteria:

• cell color
• font color
• font name
• font size
• font = bold
• font <> bold
• font = underline
• font <> underline
• font = italic
• font <> italic
• strikethrough
• has hyperlink
• has comment
• resolved comment thread
• unresolved comment thread
• protected cells
• unprotected cells
• odd rows
• even rows
• odd columns
• even columns
• visible cells
• hidden value/formula
• number format contains
• merged cells
• unmerged cells

Select cells with dates based on any of the following criteria:

• between
• not between
• equal to
• not equal to
• greater than
• less than
• greater than or equal to
• less than or equal to
• Weekday
• Month
• Year
• Quarter

You can run this tool sequentially to refine your selection using multiple criteria.

Some people use this tool as an alternative to, or in combination with, Excel's AutoFilter when they need more advanced or flexible filtering options.

By default, you can launch this tool using the Control+Alt+O shortcut.

Note:
The tool's speed may decrease if the matching cells are in many non-contiguous blocks of cells. In such an event, you can increase the speed by sorting your data first.

Starting this tool

Additional keywords to help you find this tool:
advanced Excel filtering, select cells based on conditions, advanced selection criteria, custom cell selection Excel, select cells by text length, select cells by color formatting, select cells by font style, select cells by numeric criteria, select cells by conditional logic, select cells by duplicate criteria, Excel select non-duplicate cells, select cells based on properties, match, tag, pick, underlined, white, pink, red, orange, brown, yellow, gray, green, cyan, blue, violet, black, threaded, dups, duplicates

Tip:Alt+P for the previous tool.