Good afternoon everyone -

Here's my situation, I have two columns of information that I want to "validate" before the info in those cells is used in a series of macros.

The columns in question are AF and AG, and run from rows 3 through Range("M65536").End(xlUp).Row
The "valid" characters are numbers 1 through 0 and the apostrophe (').

If the cell contains "invalid" characters I want it to shade the cell red, change font to white, and add 1 to a an integer that will feed a message box that states it found "x" number of invalid cells.
If the cells all contain nothing but valid characters then the macro continues with no further action required.


My thanks to anyone that can help,
Frank M.