You don't say what kind of data it is, but if it's simple string or numeric data, a Macro is overkill, in my opinion.
If the data is in Table form, and can be viewed as a list of 1-line "Records", then you have some good tools at your disposal. Just sorting the table on the relevant column can send all "out of range" values to the top and/or bottom, where you can easily see them. There's also the "Data Filter" menu option , where you can show or hide records by the values in columns, even "show only blanks" to highlight missing data.
For more unstructured data, you have the Conditional Formatting feature. Data matching the rule can be made to appear in a larger font, in red, etc., so you can spot it immediately. If it's a lot of data, view it at 10% Zoom. The good values are just dots, but you can make any invalid values stand out like the proverbial sore thumb.