I need to further add that cell B1 is a cell that the user can enter data into

"tracktor" wrote:

I am trying to empty a cells content based on the value of another cell.
Example: if cell A1 is "X" and cell B1 is "X" , and the contents in cell A1
is changed to "Y" then I want cell B1 to be emptied.