Office 2016 conditional formatting not updating
However, it is also very convenient to get this button after you are used to Microsoft Excel 2007/2010/2013/2016 Ribbon.Launch Microsoft Exce, click the “Home” tab, and go to the “Styles” group, then you will see the “Conditional Formatting” button there: It seems somewhat hard to get used to the new ribbon in a short time. Classic Menu for Office brings back used classic styles interface of Microsoft Office 2003 with all new feature of Microsoft Office 2007, 2010, 2013, 2016 and 365.Also, if I leave out the AND part and evaluate these conditions separately they will both return true with the conditional formatting working but not together.
There is also checking for odd/even rows for ease of reading.
Classic Menu for Office is an excellent helper to easy your learning curve.
Brings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010, 20.
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.