Greetings,

Is there a limit to how much conditional formatting you can do on a page?

I have a matrix that is 110 rows by 60 columns. I have added borders to break the matrix up into 2x2 squares, 1650 boxes total.

I am trying to format thesse boxes so that if a certain condition is met, the upper left and lower right cell of each of these boxes is highlighted (light blue background applied to each cell).

I know how to do this with conditional formatting. However, when I attempted to do this, it seemed to work, but an attempt to save failed due to Excel not being able to save all of my formatting. I clicked OK, and it appeared to save fine, but when I re-opened the document later, only half of the cells contained the conditional formatting. Trying to add the same conditional formatting to the remaining cells resulted in an error message of too large of an area selected.

Is there any other way to apply the formatting so that I can cover the entire matrix?