This Is something I was looking forward to in 2007, Unfortunately Conditional Formating Is Still Bound To One Sheet... as well as not being able to lock/unlock multiple sheets unless you're running a macro... Still Have to Copy and Paste in Most Instances to get things done on multiple sheets..