Suppose that I have $X_1$ and $X_2$ to forecast $Y$. If I run a regression on them separately, the coefficients are both positive. But if I a regression $Y = \beta_1X_1 + \beta_2X_2$ then wlog, $\beta_1$ is positive and $\beta_2$ is negative. What does this tell you about $X_1$ and $X_2$?
My thoughts are that this means $X_1$ and $X_2$ are highly correlated which throws off the betas but is there a more concrete explanation?