The Criteria: “If the Date is within the Target Range, Color the Cell Green; If the Date is previous to the Target Range, Color the Cell Red and show the Number of Days Previous to the Target Range; If the Date is Greater than the Target Range, Color the Cell Blue and show the Number of Days forward from the Target Range.” Uh… Really? Ok, well – as always – MrExcel comes to the rescue with a viable solution to reach the objective. Follow along with Episode #1696 as Bill shows us how to achieve the results.

[youtube=http://youtube.com/watch?v=hYIPGw3jgUg]

"Learn Excel 2007 through 2010 from MrExcel" by Bill Jelen…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

Visit us: MrExcel.com for all of your Microsoft Excel Needs!