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.

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,

Read more ›

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