Jim from California is trying to organize his kid’s home chores list. He was trying to mark the current weekday’s chores with conditional formatting and a cell that contained =NOW(). In Episode #1269, Bill shows us a method to solve this problem.

"Learn Excel 97-2007 from MrExcel" by Bill Jelen…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book! 

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.