View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] daidipya@gmail.com is offline
external usenet poster
 
Posts: 1
Default Auto delete cell content

HI
I have a worksheet wherein at cell C8 i have put a validation as
follows
in case the value at B8 is more than zero then only any value in the
cell C8 can be fed.

The same is working , however in case i change the value at cell B8
from any number to zero the values at cell C8 does not get deleted.

does any body knows how to tackle this