I don't use Office 2007 and I know it's ribbon menu options are greatly different to previous Excel versions, so the best I can do is to point you towards the link below which has video tutorials about Conditional Formatting in Excel 2007;


I hope that helps, but if not hopefully others here will have more knowledge.