I do not believe there is a published ranking of undergraduate programs. The College Navigator college search application (https://nces.ed.gov/collegenavigator/?s=all&p=14.1401&l=93) shows 98 colleges nationwide with a BS level educational program in Environmental Engineering (or Environmental Health Engineering).
The tuition costs for a public university in your state of residence are going to be significantly less costly than any out-of-state public university of any private university.
Environmental Engineering undergraduate programs in the state of Ohio are at;
University of Toledo
University of Cincinnati
Ohio State University
Environmental Engineering undergraduate programs in the state of Michigan are at;
Michigan State University
University of Michigan
There are some community colleges that offer associate degree programs in technological aspects of green energy.
For example, Northwest Michigan College offers an associates program in Renewable Energy Technology (https://www.nmc.edu/programs/academic-programs/renewable-energy-technology-electrical/index.html).
And, in the state of Ohio, Owens Community College offers an associates program in Alternative Energy - Photovoltaic Technology (https://www.owens.edu/academics/program/alternative-energy-photovoltaic-technology.html).
Harry recommends the following next steps:
- Visit an academic advisor for the Environmental Engineering BS program at the University of Toledo
- Visit an academic advisor at Owens Community to learn about the alternative energy program