We use the following colors for different types of cells: We have some general guidelines for model formatting, but these are not like the laws of physics (gravity, momentum, speed of light, etc.) – they’re “rules of thumb” rather than “laws of nature.” How to Color Code in Excel: Key PC and Mac Shortcuts This sample lesson from our Excel/VBA course covers how to color code in Excel and some of the key principles for formatting financial models.ġ1:02: Demonstration of Walmart Model Fixesġ9:59: Exercise – Summary Spreadsheet Fixes
