Amal wants to highlight an entire record in red when the date falls within two weeks and then, leave the ‘Done’ column not marked as True. In Episode #1441, Bill shows us the tricky Conditional Formatting method to get the results we want.

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

"Learn Excel 2007 through Excel 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”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!