At this point, I don't need to remove rows. I just want Excel to flag which rows have the ID numbers in lowercase letters.

I can manually remove them after they're flagged. Is your example the best and/or easiest way to do this?