•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
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#AI formula generation techniques
#Excel compatibility
#row zero
#worksheet
#formatting
#cell
#column
#rule
#absolute reference
#account names
#indents
#spaces
#issues
#credited
#formula
#e>0