ASAP Utilities, description of our Excel tools

With this tool you can select cells based on their value, formatting style and other properties.
You can for example select all cells between 50 and 250 or all bold cells or all red cells.

You can use the following criteria to select cells based on their contents:

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

You can use the following criteria to select cells based on formatting and more:

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

protected cells

unprotected cells

odd rows

even rows

odd columns

even columns

visible cells

hidden value/formula

number format contains

merged cells

unmerged cells

You can use the following criteria to select cells based on their date:

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

Some people use this utility as an alternative for or addition to Excel's AutoFilter.

By default this utility can be used with the shortcut Ctrl+Alt+O.

Remark:
The speed of the utility decreases if the matching cells are in many non-contiguous blocks of cells. The speed can be increased by first sorting your data.
You cannot use this utility to select cells on a condition that is set via conditional formatting.
Due to a limit in Excel, this utility can select a maximum of 8192 non-contiguous blocks of cells. More information about this is on the Microsoft website:
http://support.microsoft.com/kb/832293/en-us

Screenshots

Example screenshot: 1 Select cells based on their valueExample screenshot: 2 Select the cells with duplicated valuesExample screenshot: 3 Select by text lengthExample screenshot: 4 Select cells by their formatting and more such as bold cellsExample screenshot: 5 Select the cells with the same color as cell A2 (yellow)Example screenshot: 6 Select all cells that are strikethrough (perhaps marked for deletion)Example screenshot: 7 Select cells by date such as all dates that are on Tuesday

Practical tricks on how this can help you

Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!