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