Hi I have an excel worksheet and I am trying to code it using macros.

A1 B1
A2 B2

So A1 and A2 are labels. B1 and B2 are cells that will have user inputs. I want to code it so that If something is entered into B1 then B2 will automatically be cleared; and vice versa if something is entered into B2 then B1 will be cleared. Also, I was wondering how the macros will affect the cells that have simple if then functions in them; will the macros interfere with the functions already inplace.

Thanks