View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JR_06062005[_2_] JR_06062005[_2_] is offline
external usenet poster
 
Posts: 34
Default Disable Conditional Formatting After Page Break

I used conditional formatting so that a particular itme does not duplicate
itself in a report. However, at the top of each page I need to disable the
conditional formatting. I would certainly appreciate it if someone could
show me how to detect where the automatic page break occurs and either disble
or remove the conditional formatting for that row or cell.