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.
I'm using MS Excel 2007 and am having a hard time figuring out how to use Conditional Formatting that includes IF & AND Statements.
My goal is as follows:
Have the cell in Column AQ highlighted Yellow every time the following happens:
If the cell in the same row in Column D = 100%,AND the cell in the same row in Column AP = $0, AND Column AT is blank, then the Cell in Column AQ in that row should be highlighted Yellow.
Please let me know if you're able to assist or if you need any further information to help out. I'm not sure how to go about creating this rule in Conditional Formatting.