Color...not as easy as one may think

Soooooo.................. We selected the color with the help of the color guided computer at home depot, it should have been perfect. But it wasn't. I sat staring at the paint on our wall, luckily it was only a small section, wondering why it wasn't as beautiful as I had picuted it in my head.
After some investigating I realized that the red we had selected has too much orange in it and not enough purple. So it will be back to home depot. Now we HAVE to paint the bedroom because it has yellow walls, baby blue trim, and a large patch of red on one wall! I am really striving for a merlot like color.
I have to give props to my husband Paul for his patience throughout this decorating adventure. He is very loving towards me and humors me and my choices a lot.