•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Anything in neighbor cell messes up formatting
Our take
Are you frustrated by how changes in one cell can disrupt the formatting in another? This common issue, often seen in spreadsheets, can be a roadblock to your productivity. In the case of your worksheet, where adjustments in column G affect formatting in column E, the solution lies in refining your existing rules. By applying the formatting condition solely to column C and using absolute references in your formulas, you can regain control over your spreadsheet’s appearance.
Hi all.
This is my current worksheet:
Whenever I put anything into a cell in column g the formatting on the same row in column e gets messed up.
Circled:
Why is this happening?
I do have a current rule that adds spaces on account names if they are credited.
Just a rule for cells that checks if e>0 and then indents column c. But I do not see how that would cause issues.
Thank you for the help.
Solution was making the rule apply only to column C and made e in the formula an absolute reference ($)
[link] [comments]
Read on the original site
Open the publisher's page for the full experience