You can use Excel VBA to quickly find and select all cells that contain a specific type of data, just like using the Go To Specials command.

Returns a Range object that represents all the cells whose contents are different from the comparison cell in each column. Syntax expression.ColumnDifferences […]