How am I supposed to manage this. I know the plane automatically handles the prop, but most of the time the prop is in the yellow and sometimes in the red, which is what is necessary when taking off or climbing. What am I doing wrong? 

Are you using the DA40NG mod? In the readme it talks about the FADEC and that your prop axes (if you have one mapped) should be set at either zero or full.