Peanut
You would have to use an event (say one of the change events) and then store
that in a range name or hidden sheet. You could then check this each time
the event fires and delete it if different and save the new one in it's
'store'
It will need code so give us more detail as to when this book is
used/updated etc.
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
www.nickhodge.co.uk
"Peanut" wrote in message
...
Is there a way to delete a cell value based on a condition? i.e. Each
change
of day, the cell value in A2 will be deleted...