Column D accepts "Y" or "N"....If "Y" is chosen then a formula is entered
into column A of the same row. If "N" is chosen, then the contents of the
cell in column A are removed.
A user can put his/her own entry into the cell in column A....is there a way
that excel can recognize whether the cell contains a formula or a
value....and if the cell does not contain a formula to change the cell in
column D to "N"?