 |
| |
| Autoformat |
|
 |
|
| |
 |
| |
This tool will find and format the following kinds of cells.
Inputs: are those cells that contain dependents but not precedents.
External Links: are those cells that contain formulas with references to other workbooks.
Outputs: are cells that contain precedents but not dependents.
Formulas: are cells that contain precedents and dependents.
Is important to realize the priority of the formats
The priority order is:
Inputs, External Links, Outputs y Fórmulas.
Exaples: If a cell is Output and External Link a the same time, the External Link will have priority
Autoformat - Settings
You can configure format by default or customize the background color, font size, borders, etc.
Configure this tool in SP General Tools> Autoformat Settings
|


|
| Click on Advanced, it will display the follow dialog-box.
For example: When you only wish to change the font style but not the other parameters.
You can do it, unchecking the options no desired
|

|
We have the following model:
|


|
NOTE: In this example, the configuration is:
|
 |
| |
| |