The stars in it are relatively faint, and the glow from city street lights makes them very difficult to see from inside Columbus. It's an important constellation, though. Next time you're out in rural Ohio, you might want to give it a look.
Cancer is almost directly overhead right now in the early evening.
It is southwest of the Big Dipper, about halfway between Leo to the east and Gemini to the west. I think you know what end we're talking about here. Between the northernmost star and Acubens are two stars close together. They mark the rather beady eyes of the crab. Cancer was an important constellation to our forebears.