Hi,
I am looking for a macro that will check all cells in any column I choose (Column C for instance).
During the check, it should identify all cells in which alpha characters are not capital. (perhaps by changing the background color of the cell to red)
The only issue I see is that a cell might contain both alpha and numberic characters.
For instance, "998Test" should be flagged b/c the "e", "s" and "t" in the cell are lowercase.
Thanks in advance,
XLML
I am looking for a macro that will check all cells in any column I choose (Column C for instance).
During the check, it should identify all cells in which alpha characters are not capital. (perhaps by changing the background color of the cell to red)
The only issue I see is that a cell might contain both alpha and numberic characters.
For instance, "998Test" should be flagged b/c the "e", "s" and "t" in the cell are lowercase.
Thanks in advance,
XLML