Before using data validation, conditional formatting, rules, a formula, or changing the merge action, the property changes ...