Dear David,

thanks for the explanation. I actually AM using an event macro an
therefore everytime I modify a cell the macro runs and the change
become permanent.

I think I will take out the event macro and place a button on the shee
to run the macro AFTER all modifications have been made...

Community:
Otherwise.. is there any other possibility to do CONDITIONAL FORMATTIN
without the limitation of these 2050 something rows? I have a file tha
is 30 MB and I unfortunately cannot split the sheets into separat
files...

Thanks for any "out of the box" ideas!

Titus

--
titushank
-----------------------------------------------------------------------
titushanke's Profile: http://www.excelforum.com/member.php...fo&userid=1999
View this thread: http://www.excelforum.com/showthread.php?threadid=46919