Here's the deal.

In column M, I can enter either an "a", "b","c","d","e",or "f".

There are over 5000 entries in this column.

When I count up the total number of a's, b's etc. using COUNTIF, I get
4990.

Somewhere in my M column, there are 10 entries that are screwed up.

What I was trying to do was to (either using formulas or VBA),
highlight all the good cells in the M column and the ones containing
the bad entries would stand out (not being highlighted) because they
have an extra space, or a bad character, etc.

Hopefully, you can figure out what I am trying to do.

Help!

Thanks!



Stacy