When I do Add -> Existing Web Site in Visual Studio 2008, if the existing site was created in an earlier version of .net (say 2.0 and I'm running 3.5) Visual Studio automatically starts an update wizard to convert the site to 3.5. How do I turn off this behavior so that it simply imports the web site without updating it? I know this is possible because the first time I did this it happened flawlessly, but at the time I didn't un-check the "automatically update sites next time" check box. Gah.
How can I conditionally format an entire row in Excel based upon the data in one of the columns in that row?
How can I conditionally format an entire row in Excel 2007 based upon the contents of a particular column in that row? [more inside]