I've got several named ranges. And I use those named ranges in some
conditional formatting. Initially, I had the whole columns selected
like below, but that was taking a lot of memory, and I've been having
issues with inserting/deleting lines taking a VERY long time to
complete. But at least the conditional formatting worked.

=QueryBuster!$B:$AO

To try and help with the memory issue, I tried a dynamic range like
below. Those were accepted by the system, but my conditional
formatting broke. It's like it's not seeing the range.
=OFFSET(QueryBuster!$B$1:$AO$1,0,0,COUNTA(QueryBus ter!$B:$B))

So I went to a static range that would at least encompass the largest
dataset that I could imagine, like below.
=QueryBuster!$B$1:$AO$5000

But after I saved and next updated the workbook, the conditional
formatting still didn't work, and when I went and looked at the named
ranges, they had changed to similar as below. All of the first
dimension were at 1048537.
=QueryBuster!$B1048537:$AO4960

So, three questions:
1) What might be the possible causes for the memory issue, and
how might I resolve that?
2) What is up with the Named Ranges?
3) What's the best way to go about this?

Thanks.