LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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,
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional format Kyle Excel Discussion (Misc queries) 1 April 25th 06 07:24 AM
Conditional Format - 3 conditions Mike Saffer Excel Worksheet Functions 3 April 13th 06 07:35 PM
Office2000: Conditional format behaves strangely Arvi Laanemets Excel Discussion (Misc queries) 1 April 7th 05 08:47 AM
Date Format Question Josh O. Excel Discussion (Misc queries) 1 February 10th 05 09:45 PM
Conditional Format With SUMIF Minitman Excel Worksheet Functions 3 November 1st 04 02:58 PM


All times are GMT +1. The time now is 11:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"