I imported a table from SQL Server 2000 using an ODBC connection and I had 2 columns of dates next to each other. I conditionally formatted one column to use yellow background if the date in the other column was > the date in the current column. It works for some cells and not others. Some where both dates are exactly the same show one is > than the other and sometimes not. Some where one date is null are highlighted and some are not. Some where the date < current shade correctly and some do not. I tried formatting the dates as numbers and they match the dates - in that ones where one date > another the numbers are also > the other, and one date = another the numbers also are equal.
It's the formatting that seems to be completely random. I also tried copying the data and pasting it in as values and once it worked - when I put the conditional formatting on it worked like it's supposed to and then I tried it again and it went back to random formatting. I gave up at that point.
I am using Excel 2007 on Windows XP SP2 and SQL Server 2000 Standard SP 4.
Has anyone else ever run into this?
Thanks