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,
|