How to Use Conditional Formatting in Excel to Highlight Date Ranges
One of my viewers wanted to learn how to "dynamically" color-code a range of cells that contain dates in Excel. She sent me here Excel Workbook and it took me less than 10 seconds to recognize where she was going wrong.
I solve this problem using the new Conditional Formatting features that were introduced in Excel 2007. I use 3 rules. Each uses a formula that will evaluate to TRUE so that the Conditional Formatting can be applied.
During the video, I encourage you to "Pause and Print" your screen so that you can capture the Formulas that I used to create this video tutorial.
I cover these topics in much greater detail on my commercially published DVD-ROMs. You can learn more about my training resources when you visit - http://shop.thecompanyrocks.com.
Danny Rocks
The Company Rocks
Watch video How to Use Conditional Formatting in Excel to Highlight Date Ranges online without registration, duration hours minute second in high quality. This video was added by user Danny Rocks 10 September 2012, don't forget to share it with your friends and acquaintances, it has been viewed on our site 139,466 once and liked it 243 people.