I have a macro enabled xlsm workbook (with macros) I have conditionaly
formatted cells that will not update automatically (any of them). The cells
will update correctly if I edit the rules, but only if I edit the rules. Auto
calculation is on. This workbook was created in Excel 2003 and the
conditional formatting worked fine, it was updated to 2007, everything else
works fine, macros included. None of the conditionally formatted cells will
update, original 2003 ones or new ones. If I create a new workbook, the same
conditional formatting (by formulas) works fine. Has anyone sen anything
similar or got any ideas at all??