You can then press Ctrl + 1 to change their font color to blue, or you can access the font color commands from the “Home” tab in the ribbon menu. To find and select these cells, you can use the following PC/Windows shortcuts:į5, Alt + S, O, X: Select Constants (Drop the X if you want to highlight text constants)į5, Alt + S, F, X: Select Formulas (Drop the X to highlight textual formulas)įor example, if you press F5, Alt + S, O, X, that will highlight all constants on the spreadsheet.
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
