People have gotten into Stanford with Bs and even Cs on their transcripts. Only about 5% of admitted students are below the top 10% of their class however: http://admission.stanford.edu/basics/selection/profile.html#freshmen
It’s possible and happens, but the chances of admission generally are worse the lower your GPA/rank.