View Single Post
  #1   Report Post  
Paul987
 
Posts: n/a
Default Auto clear when qualification is met


I am working with a large sheet, where I would like some cells to clear
after a certain time. They contain data that becomes out of date.
For instance, I would like to clear contents of F16 after 5pm. The
problem is there are alot of cells, most of which have a different time
they would clear. It is also a shared sheet, so having to manually run
a macro all the time would be too difficult. Is there any way to do
this with a formula.?

Thanks
Paul


--
Paul987
------------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=474731