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

I have a report setup where I paste data into a range of cells.
The cells have a conditional formula to compare the cells to a list of cells
in column A.

I use this report on a monthly basis, and the list in column A changes every
month.
So the easiest way for me to start the new month is to make a copy of the
completed report for the previous month, and simply delete the data that I
had pasted in.

Only problem is when I delete that data, it also deletes the conditional
format for those cells

Is there a way to delete delete the data in a cell, but keep the conditional
format?

Thanks,