Hi all,

I have several large Excel sheets (tables) that I want to format conditionally, column by column. These are dynamic tables in the sense that they're updating daily/weekly with new rows. I have 100 columns and roughly 1500 rows at the moment.

In the past, I would just apply the formatting for entire columns (A:A, etc.), but I ended up with a file that was very large and which also seemed slow.

I suspected it was partly because of the color formatting, but I can't say for sure.

Now that I've improved my files otherwise and starting from scratch, I decided to format only the table content, i.e., H7:H1465. I thought this would also auto-update as my table grows in size, but that does not seem like it's the case. Please see attached picture.

Question:

1) Is it possibly to format a table in this way AND have it auto-update?

2) Perhaps H:H is OKAY and does not affect performance/size of the sheets negatively?

Proposed alternative solution:

3) Format say 1465 + 500 or 1000, i.e., H7:H2500. This should allow me to update or use a larger dataset without any trouble in a long while.

Thanks in advance for all help before I start fixing this issue.

Elijah

Formatting.png