Formatting & Themes — ModelxcelPro

Ships in every plan

First, the cell type.

Inputs and formulas are treated differently. Entered assumptions get input-style routing; calculated cells get formula-aware styling. The model stays readable because the logic and the assumptions do not look the same.

Then, the financial meaning.

Within both inputs and formulas, Smart Formatting classifies the notation: Number, Date, Percent, Factor, or Ratio. COD reads as a date. DSCR reads as a ratio. WACC, IRR, and debt-sheet fees read as percentages. Exchange-rate and FX-rate labels read as factors.

Also, references inherit.

A formula that simply references another cell takes that cell's style. =A1 doesn't get a second guess; it carries the source notation forward across sheets so the chain stays consistent.

Finally, the flags.

TRUE/FALSE and 1/0 rows are recognised as model flags when they form real patterns: through-date, after-date, between-date, or non-consecutive toggles. The TRUE or 1 cells get the flag treatment automatically.

Formatting & Themes

Excel that understands your model.

Demo coming

Smart Format SelectionCtrl+Shift+J

Precision, on demand. Select a range and Smart Formatting first separates inputs from formulas. Then it applies the right notation inside each category: Number, Date, Percent, Factor, Ratio, or Flag. COD becomes a date. DSCR becomes a ratio. WACC and fees become percentages. Exchange-rate labels become factors.

Smart Format SheetCtrl+Shift+Q

Scale, without ceremony. Format Sheet applies the same input-vs-formula logic across the active worksheet, then classifies eligible cells as numbers, dates, percents, factors, ratios, or flags. Inherit a worksheet. Apply the standard. Move on.

Auto Format (format-as-you-type)Ctrl+Shift+X

Just type. We handle the rest. AutoFormat watches eligible edits and applies the same Smart Formatting engine in the background. Inputs and formulas can both receive the right notation while you build. Helpful, not dictatorial.

Theme Gallery + Custom Designer

Set it once. Use it everywhere. Nine built-in themes (Default, Ruby, Desert, Modern, Emerald, Amethyst, Boardroom Graphite, Covenant Slate, Ocean) and a custom designer define the standards your team actually uses — colors, borders, and the number-format families Smart Format applies. Themes drive the full model look: Smart Format categories plus sheet headers, section headers, subtotals, totals, and flags. Themes persist with the workbook, so the model carries its notation grammar with it.

Flag Pattern Detection

Flags are model logic, not decoration. Smart Format recognises TRUE/FALSE and 1/0 rows when they form through-date, after-date, between-date, or non-consecutive patterns. TRUE and 1 cells get the flag treatment automatically. No rule editor. The model shows you the switch.

Empty References HighlighterTurn on Empty Referenced Cells and surface the blanks formulas are already reading. The referenced empty cells get the theme's Empty Ref style, so silent zeroes stand out before they travel downstream.
Direct style shortcutsAlt+Shift+N/P/D/F/RSkip the classifier when you already know the answer. Alt+Shift + N / P / D / F / R apply Number, Percent, Date, Factor, or Ratio directly to the selection. Inputs auto-route to the input variant so the look stays consistent.
Section HeaderAlt+Shift+HAlt+Shift+H stamps a clean section header that matches your theme — bold, aligned, ready. Apply from the ribbon or from the keyboard without leaving the cell.
Master Shortcut ToggleOne switch in Settings frees up every Smart Format shortcut at once when another add-in needs them. Power-modeler escape hatch, no rebuilds, no edits to the registry.
Text Case toolsSentence case, lowercase, UPPERCASE, and Capitalize Each Word. Apply to the selection or the sheet, or include it in AutoFormat. Choose whether text case participates in Format Selection, Format Sheet, and AutoFormat.
Undo FormattingA 20-level formatting snapshot stack for Smart Format passes. Undo restores the captured state of the formatted range, including formulas, values, styles, fonts, fills, borders, and conditional formats. A powerful rewind. Use it like one.
Input Style RoutingInputs and formulas are the first split. After that, both can be classified into the financial-model notation families: Number, Date, Percent, Factor, Ratio, and Flag. Entered assumptions and calculated logic stay visually distinct.
Auto-fit ColumnsAuto-fit column widths after formatting so pasted or inherited sheets settle back into readable shape.

Proof & TrustBind, sign, and prove every number.Audit & ReviewHand off the model with evidence.Formula IntelligenceExplain formulas, trace dependency paths, and control named ranges inside Excel.Structure VisualizationSee the whole model on one screen.Workbook ComparisonKnow why outputs moved.