Renovation Questions

How do you choose paint colors and finishes for different rooms during renovations and what tips help create a cohesive and visually pleasing palette