The validity rule is activated when a new value is entered. If an invalid value has already been inserted into the cell, or if you insert a value in the cell either with drag-and-drop or by copying and pasting, the validity rule will not take effect.
输入新数值时将激活有效性规则。如果已在单元格中插入了无效值，或者以拖放或复制粘贴的方式在单元格中插入值，则有效性规则不起作用。