The conditions and impact of star formation in a multi-phase interstellar medium