Conditional formating update fail

[tohor]

Hello guys,

I´ve got small issue with Excel 365 and conditional formating. Suddenly conditional formating (color changing based on cell value) is not working correctly as it seems that it updates only in few cells unless I scroll with changed row out of viewable window and back or save and reopen this sheet. Sometimes also Ctrl+s helps...

Point is that in new sheet the same conditional formating works normally.

Is there any hidden option in Excel for conditional formating screen updating? Could be reason for this non-updating amount of rows?

Thanks
Tomas

[excelliot]

check whether calculation option is Manual or Automatic? If manual set to Automatic.