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: