I'm trying to learn VBA to get some special features into a spreadsheet I am creating using Excel 2007. I'm trying to use condition formatting where, by selecting "Open" from a drop down list the entire row becomes formatted. How can I do this and for multiple rows?