Good advice regarding the local Paint Stores. Most of the people at ‘Big Box’ type hardware stores tend to not have any real idea about what they’re selling, and earn a little over minimum wage. I believe the only requirement to work in those places is having the ability to lift 20lbs, give authoritative bullshit answers, and fog a mirror. Hiring people that have actual real knowledge of their in-store departments would cut into profit margins, which are about ALL that matter for such places.....
At Home Depot, they will always answer your questions and suggest products, although they usually know nothing, on the rare occasions when I have had to go to one, I will ask them questions, and am usually amazed at the stupid answers, but they are always confidently given.
They never just say, "I don't know".