I'ld like to help, but without seeing a sample of what you got, is hard.

I don't understand why you can't just clear the contents of the scratched horse.
And if it stuffs up your Formulas, then alter the Formula to begin with an IF Statement.