I'm not familiar with the terms exactly so if I need to be corrected please update my post.
The picture should exemplify what I'm trying to achieve. The colored areas are not naturally colored so ignore the colors if trying to find them on another instance of Excel 2010.

