Conditional Formatting type of operation

Loss of UNDO is a problem with all macros and you would have
even more of a problem if you chose to use an Event macro because it
is always there.

Dear David,

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

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

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

Thanks for any "out of the box" ideas!

Titus.