Module VI· Excel Setup & Best PracticesBasic
Question
What color-coding convention is used in IB models?
Answer
Common convention: blue font for hardcoded inputs, black for formulas, green for links to other worksheets, red for external links or important flags, and sometimes purple for macros / special cases. The exact convention can vary by bank, but consistency matters more than the specific palette. Never hide hardcodes inside black formulas.