LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Conker10382
 
Posts: n/a
Default How do I revert cells to blank automatically on spacific days?

Does anybody know of a function, formual, or macro on Excel 2003 that I can
use so that my spreadsheet will automatically erase information in certain
cells on certain days? For example: On May 25th I will enter "YES" in cells
B5 and B6. I want cell B5 to automatically revert to a blank cell on June
5th and cell B6 to revert to a blank cell on June 11th. There aren't many
things that you can NOT do with Excel. Did I find one?
 
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
OFFSET to include blank cells GMCN Excel Worksheet Functions 2 April 3rd 06 10:11 AM
pivot tables reports - altering display of (blank) cells cak Excel Worksheet Functions 1 August 22nd 05 12:39 AM
CONCATENATE problem with blank cells roger_home Excel Discussion (Misc queries) 1 August 17th 05 09:18 PM
Blank cells represented in area charts cdoughty Charts and Charting in Excel 2 August 6th 05 06:02 PM
Automatic copying data excluding blank cells Wesley Excel Worksheet Functions 6 November 30th 04 01:17 AM


All times are GMT +1. The time now is 12:42 AM.

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"