D
Dan
Excel 97, Win NT Version 4 (build 1381, service pack 6)
OK, I read a post by someone that stated that there was a
maximum of 4500 formats that can be used in an Excel file.
The thing is I can't be close to that in a newly created
file, but yet when I apply conditional formatting to a
group of cells and duplicate them, Excel crashes when I
try to save the file.
I was originally adding the conditional formatting to an
existing file that I use to keep track of the time off
used by my crew. We run on a 2 week pay period, with 5
people. I have been told recently to keep track of the
number of times they miss a punch, or forget their ID/time
card.
After applying the formatting to 26 pay periods I tried to
save the file-CRASH!
After reading about the 4500 format limit I recreated the
file (after the crash the file was unreadable), and I
removed alot of the other formatting.
The end result was the same.
Is there a limit to the number of conditional formats that
can be used?
Is there a work around?
Thanks in advance.
OK, I read a post by someone that stated that there was a
maximum of 4500 formats that can be used in an Excel file.
The thing is I can't be close to that in a newly created
file, but yet when I apply conditional formatting to a
group of cells and duplicate them, Excel crashes when I
try to save the file.
I was originally adding the conditional formatting to an
existing file that I use to keep track of the time off
used by my crew. We run on a 2 week pay period, with 5
people. I have been told recently to keep track of the
number of times they miss a punch, or forget their ID/time
card.
After applying the formatting to 26 pay periods I tried to
save the file-CRASH!
After reading about the 4500 format limit I recreated the
file (after the crash the file was unreadable), and I
removed alot of the other formatting.
The end result was the same.
Is there a limit to the number of conditional formats that
can be used?
Is there a work around?
Thanks in advance.