Thank you both for your inputs. I will try to get back to this sometime this week, they kind of put this on the backburner for now, and it takes a while to notice if the file changes size. The growth is gradual/exponential so I'll let you know when I know something.

Also, the conditional formatting is about 20 cells on all 4 worksheets (80 cells) that just checks a date function and changes text colors, so not a lot. The entire file is only about 40 rows by 7 columns on each worksheet. It really isnt hardly any data at all, thats why it is so weird that it is doing this.