Microsoft Office 2010 Professional Video Tip Cond

Today's author: Sam Radakovitz,Windows 7, a Program Manager on the Excel team that enjoys creating VBA applications in Excel. A bit ago,Office Enterprise 2007, Joseph had a blog post about community clips on OfficeLabs.com, so for this post, I wanted to take advantage of the video demonstration and do the post via community clips. The topic is an Excel tip about using conditional formatting and data validation to turn on and off the formatting on the sheet without needing VBA code. The video can be found here and is also embedded below. The workbook I used is attached to this blog post if you want to play around with it, and since you can't really see the formulas I used in the video, I'll post them here and add them to the comments of the video: Data Validation formula: =options Conditional Formatting formula: =IF($B$2=$A$13,1,0) This was my first attempt at a video and I had some video problems around the screen capture failing on me and the microphone volume. I'll work to fix those issues if I do this again. I'm curious to hear from folks if they like the video post,Windows 7 Ultimate, or would prefer to keep things in text,Microsoft Office 2010 Professional, or a mix of both. Thanks,Microsoft Office 2007 Professional! <div