Explain conditional formatting rules

Project sourcePopulation

Teaching · read-only · Records!D2

Step 1 / 4Inspect the typed source records

Inspect

Records retains original numbers, text and true blanks. Inspect the source before interpreting a colored Report cell. Teaching is read-only; switch to Your turn to edit.

Records!D2 · (blank)
No formula applied

Loading your interactive spreadsheet…

Edit an actual worksheet cellSheetCellTypeValue

Workbook minimum: Blank · Report minimum: Blank · Review date serial: Blank

Name bindings — 5 registered names

Bindings use absolute cells or ranges on Policy. Scope changes where a name is available. Applying these bindings preserves cells and starts a new worksheet history. Rule formulas keep the names you typed.

Draft name definitions

NameScopeRefers to

Report rules, in priority order

Use formula rules within Report!A2:E9 and the Policy names above. The rules use real formula calculations. Their current fills and bold appear on the actual Report worksheet; the table below is a calculation audit.

Rule manager

Rule 1Applies toFillBoldStop If TrueEnabled

Condition

Rule 2Applies toFillBoldStop If TrueEnabled

Condition

Rule 3Applies toFillBoldStop If TrueEnabled

Condition

Explain the linked review policy

Where should the configurable threshold live?Does formatting change the underlying invoice values?

Current workbook inspection

[]{"undos":0,"redos":0}

Native copies contain three source worksheets, audit snapshots, scoped names and Excel formula rules. Fixed copies contain the current values and appearance. Desktop Excel recalculation/edit/save and Google Sheets remain separate checks. Everything here stays in your browser.