Selectif function

[Cawshus]

Hi

I need to be able to select in a worksheet all occurances of a user-
specified value (examples - select all zeros; select all values = "test").
The ability to specify exact match or contains would be useful.
Can someone point me in the right direction.

 

[Cawshus]

I would turn on AutoFilter, then in the column in question use the
drop down arrow and select CUSTOM.

That would work in one row, I need it to work across a whole worksheet or
selected range.

 

[JBeaucaire]

I would turn on AutoFilter, then in the column in question use the drop down
arrow and select CUSTOM.