A person who is intelligent and hard-working will do well at a university. Visual learners and auditory learners usually do best if there is a lot of lecture involved. But any learning syle can work. Just study the way you are most effective and comfortable.
Your first couple of years will be taken up by mostly general education classes. These are classes designed to give the students a good solid foundation before the begin the classes that will be part of their major. Your learning styles might have to be set aside as many college professors teach one way-lecture and notes.
The first couple years of college are likely to be straight lecture and note taking type of delivery systems. You may have some science classes that have a hands-on lab component that go with the lecture. Once you get into your Major field of study you may experience some different teaching styles.
If one attends some small non-competitive colleges, more adaptations are made for students who need remediation and have lower abstract intelligence. However, the larger and more selective universities do, indeed, expect students to be equipped with linguistic and analytical skills.
Moreover, a college student must learn how to learn on his/her own. Taking notes, acquiring listening skills, highly-motivated studying are all necessary for success. After all, universities are institutions of higher learning.
If you're talking about Gardner's multiple intelligences, I would say that you need linguistic intelligence and/or logical-mathematical intelligence. It would be best if you had both.
The rest of the kinds of intelligences aren't going to do you that much good in college because professors worry about bodily-kinesthetic intelligence or anything like that. It's go to lecture, do the reading kind of classes; and, so, you need the more traditional kinds of intelligence.