I recently had to reinstall my Office 2007. Since then, I've had no cell shading in either normal or conditional formatting. I've repaired, uninstalled, reinstalled several times, but the results are the same. It worked before.