Edit a source value, move a rule, then inspect why each cell keeps its format. Calculations stay in this tab.
Step 1 / 4Read the actual source and controls
Numbers, text and true blanks remain different source values. Minimum and As-of date live in H2:H3.
Loading your interactive spreadsheet…
Review · D2
Current worksheet values and written formulas
| Cell | Stored value | Formula | Native fill | Native bold |
|---|---|---|---|---|
| A2 | null | false | ||
| B2 | null | false | ||
| C2 | null | false | ||
| D2 | null | false | ||
| E2 | null | false | ||
| A3 | null | false | ||
| B3 | null | false | ||
| C3 | null | false | ||
| D3 | null | false | ||
| E3 | null | false | ||
| A4 | null | false | ||
| B4 | null | false | ||
| C4 | null | false | ||
| D4 | null | false | ||
| E4 | null | false | ||
| A5 | null | false | ||
| B5 | null | false | ||
| C5 | null | false | ||
| D5 | null | false | ||
| E5 | null | false | ||
| A6 | null | false | ||
| B6 | null | false | ||
| C6 | null | false | ||
| D6 | null | false | ||
| E6 | null | false | ||
| A7 | null | false | ||
| B7 | null | false | ||
| C7 | null | false | ||
| D7 | null | false | ||
| E7 | null | false | ||
| A8 | null | false | ||
| B8 | null | false | ||
| C8 | null | false | ||
| D8 | null | false | ||
| E8 | null | false | ||
| A9 | null | false | ||
| B9 | null | false | ||
| C9 | null | false | ||
| D9 | null | false | ||
| E9 | null | false | ||
| H2 | null | false | ||
| H3 | null | false |
Use the current course instructions above. Repair the rules below, calculate and inspect the decision trace, then check this lesson.
Supported formula scope
This workshop supports bounded local A1:H13 references and scalar conditions using AND, OR, NOT, IF, IFERROR, ISNUMBER, ISTEXT, ISBLANK, ISERROR, COUNTIF, COUNTIFS, SUM, MIN, MAX, AVERAGE, MEDIAN, COUNT, COUNTA, PERCENTILE.INC, PERCENTILE.EXC, SUBSTITUTE, MOD, ROW, COLUMN, UPPER, LOWER, LEN, TRIM, ABS, ROUND, SEARCH, FIND, INDEX, EXACT, TRUE and FALSE. Conditions apply for TRUE or a nonzero number. Errors remain visible and do not stop later rules. Array conditions, named ranges, indirect/volatile/external reads are separate work.
Scales accept two or three colors, numeric/percent/percentile thresholds and minimum/maximum endpoints. Percent divides the minimum-to-maximum span; percentile interpolates the sorted numeric values. Out-of-range values clamp to endpoint colors. No numeric cells means no scale format. At equal thresholds the browser uses the earliest stop at equality; native gradient rounding and equal-threshold rendering are not certified.
Icon previews use original teaching artwork. Native downloads use Excel's standard icon families; frozen downloads embed static pictures while retaining source values. In icon-only mode the preview/download hides numbers; the source inputs remain editable. Exact native artwork and client compatibility have not been certified.
Formula thresholds start with =, use absolute references within A1:H13 and must return one finite number. They can read the full source and H2/H3 settings. Relative references, unnamed ROW/COLUMN context, external or volatile reads and multi-cell results are outside this workshop.
Data bars use numeric-only cohorts and normalized preview geometry. Automatic endpoints include zero; lowest/highest use the actual cohort. Axis-free lengths interpolate the two endpoints. With a zero axis, lengths scale within the available positive/negative side; zero has no bar. Equal nonzero endpoints use the maximum length. Context direction is left to right on this sheet. Native x14 rules retain the selected options; older clients receive a legacy fallback. Exact native pixels, mixed-sign length adjustments and client round trips are not certified.
Microsoft conditional formatting documentation ↗
Linked workbook project
Keep the data, policy and report connected
Change a review threshold, date or status list on Policy. Calculate named formula rules against the live Report, then inspect which rule wins.