Learn Excel – “Has Formula?”: Podcast #1351

Ricardo has a Spreadsheet where active projects include live Formulas. Once a project is complete, he converts the Formulas to Values. He wants a way to mark all of the Cells which are still live Formulas by chnaging the color of the Cell’s Data. Today, in Episode #1351, Bill shows us how to use a UDF [User Defined Function] to accomplish the task – using one (1) line of VBA [Visual Basic for Applications] to keep the process dynamic and reflect future changes in the Data Set.

…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.

Duration : 0:3:6

Technorati Tags: , , , , , , , , , ,

Tags: , , , , , , , , , ,

Leave a Reply