Patricia asks how to mark the last record in each category. Episode #1274 shows you how to use ‘old-school’ Conditional Formatting formulas to solve the problem. So, what do a Database, an Absolute Column Reference and a Relative Cell Reference have in common? Find out in Episode #1274!

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

"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!