Excel does give hints when formulas are out of pattern. It's called "Inconsistent Formula" and it's displayed with a little triangle on the box.