Decompose Formula  
 

Many times we would like to determine the origin of each of the cells forming part of a formula,
including cells in other sheets, numeric values of the formula; and even cells originating from other workbooks.

This tool performs this task.
Let us see an example:
We position ourselves in a cell containing a formula.
We then press the Decompose formula button and the dialogue box will ask for a cell to start unfolding the results.

 
 
After we press the OK button, we will see the following result:
 
 

Results in yellow indicate that these cells belong to the active sheet.
The result in light blue tells us that there is a cell in this formula which originates from a different sheet.
Finally, the result in gray is the original formula which has been again rebuilt in the active sheet.

The colors can be customized; all you need to do is to access the Settings button of this dialog box.

 
Decompose Formula
In this section we can customize the colors we wish the Decompose Formula tool to show.