Shading on highlighted range of cells
 

This is going to be hard to explain but here it goes.

I am using Excel 2007. I would like to darken the shading when I highlight
a range of cells. The problem I am running into is some of the workbooks
that I inhierted have data in the cells that are white. When I use Excel
2003 I could highlight a range of cell and the cells that had data (with text
color as white) could be seen. With Excel 2007 this is not the case. So is
there a way to change the shading when I select a range of cells? Any help
would be appreciated. Thanks.