View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Another Conditional format question

Hitting the delete key will delete the contents of the cells and not
change the formatting. Deleting the ROW or CELL will delete the cell,
and therefore the new cell at that point will not have the formatting
in it. My own method would be to start with a BLANK monthly report,
which would be read-only and would therefore serve as the template.