Forum Discussion
Inconsistent Formula
I need help trying to figure out why adding or deleting a row, or dragging and dropping data to create a row is causing Inconsistent Formulas in one column. For example, the excel spreadsheet is not ...
That's why I'm requesting assistance. I know that if I only added or removed a single cell, then things would shift. I inserted a complete row, and for some reason it caused those cell formulas to misalign, all the way down the spreadsheet.
I cannot reproduce or explain that...
Result: there were cells that had Conditional Formatting rules set. Once those were removed, i was able to Insert/Delete rows without the above or below formulas being affected/shifting/misaligning.
- Thanks
