Excel Tutorial - How to Color Code Financial Models

This will cover how to color code your financial models so that hard-coded numbers and constants are in blue, formulas and text are in black. By “Financial Modeling Training And Career Resources For Aspiring Investment Bankers“ You will also learn how to make the links to other worksheets show up in green. In addition to a simple method using the F5 shortcut key to jump to different cell types, you’ll also learn how to use VBA code to accomplish this in a more elegant way
Back to Top