•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com