I understand you can't change value of a cell from within a function. ie. =Function(B12)

If the value in B12 changes to a 1 then I want the VBA code to clear the contents of this particular cell.

Range("B12").ClearContents works great from a Sub but does not from within the Function code.

Any ideas?