Excel 2016 conditional formatting not updating
1) When something from INSIDE the "applies to" is cut/pasted outside of this range.
2) When there are merged cells inside the "applies to", and any of the rows or columns get adjusted.
Thought that might help us reach the solution on this. Just Move to a cell which is in range (the one not broken of the Range), click on Format Painter and then paste on whole Column.
And how do I get my Excel to calculate and update formulas automatically again?
This section provides a summary of the most common mistakes people make when creating formulas in Excel and solutions to fix them.
As you know, the arguments of Excel functions are entered within the parentheses.
Please see How to highlight and match parenthesis pairs for more information.
All Excel functions have one or more required arguments.