Monthly Archives: March 2012

Tom’s Tutorials For Excel: Monitoring Changes in Data With Conditional Formatting


Tom’s Tutorials For Excel: Monitoring Changes in Data With Conditional Formatting Without any programming involved, you can monitor a workbook for cells that were changed from their original values. In the first set of pictures, range B5:B8 is being monitored by Conditional Formatting in hidden columns D:E. Pressing Alt+O+D calls

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Returning a Formula’s Arguments


Tom’s Tutorials For Excel: Returning a Formula’s Arguments I saw a question last year on one of the Excel newsgroups, asking for a way to return a formula’s arguments. I wondered, as you probably are, why this person wanted such a thing. Still, I was intrigued at the question, so

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,