Persistent Conditional Formatting

[scrupul0us]

I have added two conditions to my workbook (i tried recording this but to no avail) and whenever i cut/paste new data in I have to go back to conditional formatting and hit OK to have it reapply... is there a way to make the formatting persistent?

if it helps:

Condition 1:
Formula Is: =AND(MOD(ROW(),2)=1,ROW()<>1)
Format Is:
-backgroundColor = #FFFFCC
-borderLeftColor= #FFFFCC
-borderMidColor = #FFFFCC
-borderRightColor = #FFFFCC

Condition 2:
Formula Is: =AND(MOD(ROW(),2)<>1,ROW()<>1)
Format Is:
-backgroundColor = #FFFFFF
-borderLeftColor= #FFFFFF
-borderMidColor = #FFFFFF
-borderRightColor = #FFFFFF

Alternating row colors of pastel yellow and white with no visible cell borders that takes a header into account...

All text colors and fonts are the default... Can anyone possibly macro this so I can stick it in Workbook.OnChange or Workbook.OnUpdate

Thanks!

 

[Peter_SSs]

Perhaps using Edit|Paste Special...|Values (or Formulas if that suits what you are doing) instead of the standard Paste might help.

 

[scrupul0us]

I'd rather use a macro if at all possible... When I cut rows and right click I only get the option to insert the cut cells and not paste special...