Office 2016 conditional formatting not updating
How to Bring Back Classic Menus and Toolbars to Office 2007, 2010, 2013, 2016 and 365?
Just download Classic Menu for Office 2007 or Classic Menu for Office Kutools for Excel: 120 Powerful New Features for Excel.
Look at the bottom of the Excel window for the words CIRCULAR REFERENCES.
Like circular logic, a circular reference is a formula that either includes itself in its calculation or refers to another cell which depends on itself.
Supports all languages, and all new commands of 2007, 2010, 20 have been added into the classic interface.
If you prefer keyboard shortcuts, you can recalculate by pressing the F9 key.
When a cell formatted as General and the cell contains a reference to another cell, Excel copies the format of the referenced cell.
Choosing any format other than General will prevent Excel from changing the format.
Be aware that a circular reference can, in some instances, prevent Excel from calculating a formula.
Correct the circular reference and recalculate your spreadsheet.