This only happens in "proper" tables. When you add a formula to a table column, Excel will automatically convert it into a "calculated column," so overridden values will have a green mark denoting an "inconsistent formula."

It's still a pretty minor warning and it only requires two clicks to ignore.