Question: If I have B's, C's and D's on my high school transcript, can I still get a scholarship?
The C's and D's will make it hard to get a scholarship, but definitely not impossible.
There are two general types of financial aid ... one is "merit aid" that students typically receive due to various talents or achievements. These could include academic talent, artistic talent, athletic talent, etc. So even if your grades aren't so hot, and you're not in the running for academic merit awards, you may get scholarship money if you have abilities in other areas. Sometimes your background alone (race, ethnicity, where a parent is employed, first-generation to college, etc.) is enough to provide you with merit money, even without a strong academic record. I suggest that you go to FastWeb.com, sign up, and fill out the questionnaire. (It's all free!) Once you've submitted your responses, the computer will generate a list of scholarships for which you may be eligible. You will still have to apply for these scholarships, which can be time-consuming ... and the bigger they are, the more competitive they will be ... but at least you will be able to see what some of the options are. And, if you make an effort, you may be rewarded with some scholarship money.
The other type of financial aid is "Need-based" aid. This money goes to students who qualify for it because of family income and assets. It is not determined by grades. Need-based aid is provided by the US government to US citizens and Permanent Residents and also may come from the colleges themselves, once you have been admitted. If your GPA is low, there are still colleges that will admit you. At the time that you apply, you should also fill out the FAFSAform (Free Application for Federal Student Aid). This will determine if you are eligible for need-based scholarships. Then, once you receive your acceptance, you will also be given a "financial aid package" that will probably include some "grant" (that's the good stuff that you don't have to pay back) and some "loans" (which you do). The package will probably also include "Work/Study" which means a campus job that will help you earn spending money, etc.
So if you are motivated to go to college, despite some bad grades, and if you are persistent, you should be able to find the money that will enable you to do so.