1 min readfrom 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:

https://preview.redd.it/0ya0o44hfxjg1.png?width=1255&format=png&auto=webp&s=17ce582d2155b81a1c109beff43c790ac4a393eb

Whenever I put anything into a cell in column g the formatting on the same row in column e gets messed up.

Circled:

https://preview.redd.it/pgd43k8pfxjg1.png?width=967&format=png&auto=webp&s=624138ccb7326b7e63fc218c51d33de67fef8c8a

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 ($)

submitted by /u/MasterAndrey2
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com