M
Matt Day
Hello,
I have a spreadsheet that has about 1200 rows many of which need to have
conditional formatting. I had a template set of rows that I was transferring
the conditional formatting from and it worked for 20 or so rows. Then in
attempting to both copy/paste and drag formatting even further I noticed
that the conditional formatting was not being transfered to the target
cells. I have even tried doing one row of formatting at a time but it seems
like it will not allow any more conditional formatting. The spreadsheet is a
good size (about 2MB). I recieve no error messages about this. It simply
does not transfer any more conditional formatting. I tried closing the
spreadsheet to see if it was some sort of cache/clipboard problem inside the
sheet but that did not help.
Is there some sort of cap to how much conditional formatting you can have on
a spreadsheet? Any suggesitons?
Thanks
Matt
I have a spreadsheet that has about 1200 rows many of which need to have
conditional formatting. I had a template set of rows that I was transferring
the conditional formatting from and it worked for 20 or so rows. Then in
attempting to both copy/paste and drag formatting even further I noticed
that the conditional formatting was not being transfered to the target
cells. I have even tried doing one row of formatting at a time but it seems
like it will not allow any more conditional formatting. The spreadsheet is a
good size (about 2MB). I recieve no error messages about this. It simply
does not transfer any more conditional formatting. I tried closing the
spreadsheet to see if it was some sort of cache/clipboard problem inside the
sheet but that did not help.
Is there some sort of cap to how much conditional formatting you can have on
a spreadsheet? Any suggesitons?
Thanks
Matt