In block formula's analyzer  
 

This utility as it´s name indicates, allows us to analize in a specific range, a group of formulas and all the precedence/dependence connections between them.

There are two options for this:

Auditing arrows:
Shows the precedence/dependence connections between the formulas inside a selected range.

Gridlines:
Permit us to determine the connections or patterns that has been applied to create the formulas in this specific range.

This option will show this type of grid: when it determines that until this cell, a new type of formulas begins.

This option will show this type of grid: when it detects that the analized cell have a formula accordant to the creation pattern, similar to the cell on its left side.

It will show this type of grid: when it detects that the analized cell have a formula accordant to the creation pattern similar to the cell above it.

It will show this type of grid: when it detects that the analized cell does not comply with a formula pattern between the cells that are above, below, at the left or at the right side of it.

For example:

Select a range with formulas:

Select the tool with a click in the correspondent button in the tool box. The next dialog box will appear:

 
 

Before you press the button: ´Doit`, optionally we can change the colors that the tool will use. In this case we have selected the yellow and red colors.

 
 

Opcionally, you will be able to configue the Test and Highlights options to find out and check the option you want. Simply, click on the corresponding check opcion and press Ok.

 
 

After you press the Ok button, we will be again facing the dialog box.
Click on the Do button to execute the tool.
Then, the results.

 
 

Observe that because of the grids that the tool made, we can clearly determine that all the columns have a creation pattern similar to the first column.

Imagine this is not like this, maybe the grids would allow us to find out an unusual or abnormal situation.
Imagine now how useful this tool can be.
After the analysis of the selected range, we can revert the changes clicking the 'Erase auditing arrows' button.

 
Note:
If you have run the Do it ! button and then you want to clear the arrows and gridlines, simply press the button "Clear gridlines,arrows and highlights"
 
The button to clear the gridlines will be visible after pressing the doit button "Do it ! "
 
The opction : "Change color" for the arrows is not available in Excel 2007