MS Excel 2010 Conditional formats not calculating


 Just set up your conditional formatting in the cell's you want.
Make sure you activate the "Developer" tab in the menu.
Do this by clicking on the Office button, click on Excel options and in the "Popular" section check the box ""Show developer tab in the Ribbon".
Click on the Developer menu and go to the Visual basic view.
Click on the nemu View and select "properties Window". In that list you can find the "EnableFormatConditionsCalculation".
Set this value to "True" and the auto refresh will work.
Perform this action for all tabs in your sheet.

Property EnableFormatConditionsCalculation As Boolean