Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional format | Excel Discussion (Misc queries) | |||
Conditional Format - 3 conditions | Excel Worksheet Functions | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
Date Format Question | Excel Discussion (Misc queries) | |||
Conditional Format With SUMIF | Excel Worksheet Functions |