Standards vary between different groups and firms, but you almost always see the following:īlue w/ yellow background and border = Input cell. Makes it easy to see at a glance what is a formula vs. Here's an outline of what we cover in the lesson, along with the shortcuts used and the VBA code that you can use in your own models and spreadsheets: 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 that checks for different cases. You will also learn how to make the links to other worksheets show up in green. 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.īy 'Financial Modeling Training And Career Resources For Aspiring Investment Bankers'