Hi

This is has never occured to me before and after several tries I am
convinced it is nothing to do with my input.

I copy and paste a block of cells which contain conditional formats then
check that the pasted cells have the formatting. Everything is Ok so I
close the file. On re-opening I test the cells and find the first 7000ish
rows are ok but after that the formatting is missed from random cells.

The aim is to have 28550 rows with conditional formatting on columns B to
I - Can Excel cope with this amount?

I recorded a macro to copy 81 rows and paste the info in the cells below
then save. I checked the formatting and everything was OK after I closed
the file and re-openend. I then ran the code from a macro button (many
clicks later) and occasionally checked the formatting. Everything seemed OK
but when I closed the file and re-opened I have lost a lot of the
conditional formatting. As I had included a "save" within the macro I
thought It would have been ok.

I suspected this old work PC to be underpowered at 1595Mhz and 768mb
physical memory so I tried it on my AMD 6400+ with 2 Gb ram and still had
the problem.

Can anyone shed any light onto the reason for the disappearing
formatting!?!!

Kenny W
XP pro
Office 2003