On May 13, 8:41*am, wrote:
On May 13, 8:34*am, Keith74 wrote:

check the data its failing on, it's probably something that its having
problems converting to a date.

Column B where its checking the dates from are all in this format
07/23/2007 and keeps doing the mismatch error

ok i found the problem and it work fine now.
one quick question. how do i make a specific column one color and with
borders
i have 4 columns and column D is the one i need with