I'm having a problem with conditional formatting of a workbook that was originally created in 2004 and has been converted to the new format. It's a color banding formula that highlights groups, but it doesn't seem to be working properly at all.

If I paste the date to a new workbook as values it works properly. but I cannot get it to work properly in the old workbook, is there any solution to this besides recreating the workbook?

Thanks

Chris