I think it totally depends on what you are making. Most of the time it won't be a problem at all, but if for example you are making a white clam sauce, a red wine will taste just fine, but will make it look funny.

There are a few delicate sauces that I would not want to use a Pinot or Cabernet for if it usually used a Sauvignon Blanc, things like that.