To create a quick subtotal, I want to select several cells on my Excel
workbook then view the total Excel figures at the bottom of my screen.

Excel 2003 showed great highlighting that would show me easily what cells I
had selected. How do I get Excel 2007 highlighting to do the same? Right
now the default is the same color as the unselected cells.