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.
For more information about Excel VBA [Visual Basic for Applications] see:
Live Lessons Excel VBA and Macros DVD Here
Visit the MrExcel Store, select the product of interest and then click the “Read More” link for that product to see what it has to offer you.
Entry filed under: Learn Excel 97-2007, Learn Excel from MrExcel, MrExcel Podcast, MrExcel Products, VBA and Macros. Tags: 2010, accounting, Bill Jelen, business, color, Data, Excel, Excel 2003, Excel 2007, Excel 2010, formula, Functions, Macro, MrExcel, spreadsheets, technology, tutorial, UDF, User Defined Function, VBA, Worksheet.