If you're using the same level of sharpness (usually mild, medium, sharp, or extra sharp), you won't notice any flavor difference between the two kinds of cheese. Yellow cheddar is colored by annatto (or achiote) - but that doesn't affect the flavor. Most recipes that call for both do so because having two colors of melty cheese just looks lovely.