How to use VBA to write a macros that will format all the cells in the workbook? : I have recently started to use VBA Excel for financial modeling purposes and already found that it can optimize my work process. 

Right now I try to develop a macro that will help me to automatically format all the cells in the workbook, and I have no idea how to write such macro.

What I want to do is the following - I have 3 types of numbers: 

 1. Hard Numbers
 2. Numbers that are internal links - they are values from other sheets of the workbook.
 3. Numbers that are external links - they are values from other workbooks.

Is it possible to write a macro that will format cells depending on type of number (mentioned-above)? 

Thanks

 