.... So I am trying to apply conditional formatting to a document of mine and I cant seem to figure out how to make this conditional formatting work. I have in column A numbers formatted this way, here is an example: 00087965. When the numbers are not formatted this way I need it to be flagged in red or blue. Any suggestions.....?