You could achieve the same effect with a macro linked to the
worksheet_change event which deletes the new value if the value to the
left is Y.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column 2 Then
If Target.Offset(0, -1) = "Y" Then
Target.Value = ""
End If
End If
End Sub


--
mrice

Reserach Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=535686