BlueConfetti

Guides / Flint Table Filter

FLINT TABLE FILTER · HOW-TO

Highlight cells that need attention with conditional formatting

Filtering removes what you do not need; highlighting marks what matters in the rows you keep. Color the cells that need attention while the whole register stays in view.

What you will end with: all 20 entries of a risk register still visible, with the 2 Critical severity cells marked Negative, the 5 scores above 15 marked Warning, the 4 empty Owner cells marked Information and the 4 Closed status cells marked Positive, shared with the team as a view.

What conditional formatting colors

Each rule tests one column and colors that column’s cell when the condition matches. It does not color the whole row. Use several rules to mark several columns.

Sample register: risk-register.csv · 20 rows, 8 columns, fictional data. This is the register from the risk review guide.

First 4 rows
RefTypeDescriptionOwnerSeverityStatusDueScore
R-01RiskPayment provider contract lapses before renewalDana KimHighOpen2026-11-2016
R-02IssueNightly backup job failed twiceOmar HaddadCriticalOpen2026-11-0520
R-03ActionUpdate supplier contact listGrace LiuLowClosed2026-10-304
R-04RiskKey engineer on extended leave in December(blank)MediumOpen2026-12-0112
Show all 20 rows
RefTypeDescriptionOwnerSeverityStatusDueScore
R-01RiskPayment provider contract lapses before renewalDana KimHighOpen2026-11-2016
R-02IssueNightly backup job failed twiceOmar HaddadCriticalOpen2026-11-0520
R-03ActionUpdate supplier contact listGrace LiuLowClosed2026-10-304
R-04RiskKey engineer on extended leave in December(blank)MediumOpen2026-12-0112
R-05IssueCustomer export emails delayedOmar HaddadHighMonitoring2026-11-1215
R-06ActionRotate shared service account passwordDana KimHighOpen2026-11-0315
R-07RiskData center migration overlaps peak seasonFelix WagnerCriticalOpen2026-12-1525
R-08IssueDuplicate invoices for three customersGrace LiuMediumClosed2026-10-289
R-09ActionReview vendor security questionnaire(blank)MediumOpen2026-11-068
R-10RiskOffice lease decision delayedFelix WagnerLowMonitoring2027-01-156
R-11IssueMobile app crash on older devicesOmar HaddadHighOpen2026-11-1816
R-12ActionPublish incident reviewDana KimMediumOpen2026-10-3110
R-13RiskSingle supplier for replacement laptopsGrace LiuMediumMonitoring2026-12-1012
R-14IssueSupport queue above target for two weeks(blank)HighOpen2026-11-1316
R-15ActionTest disaster recovery runbookFelix WagnerHighClosed2026-10-2015
R-16RiskNew privacy regulation affects sign-up flowDana KimMediumOpen2027-02-019
R-17ActionConfirm holiday on-call coverageOmar HaddadLowOpen2026-11-254
R-18IssueSearch results stale after reindexFelix WagnerMediumOpen2026-11-0212
R-19RiskBudget approval for monitoring toolsGrace LiuLowOpen2026-12-206
R-20ActionArchive retired project spaces(blank)LowClosed2026-10-152

Step 1: Add the rules

  1. Open Saved views and presentation, then Conditional formatting.
  2. Set Format column to Severity, Condition to Equals text, Comparison value to Critical and Appearance to Negative. Choose Add formatting rule.
  3. Add three more rules the same way:
Four formatting rules
Format columnConditionComparison valueAppearance
SeverityEquals textCriticalNegative
ScoreGreater than15Warning
OwnerIs emptyNone neededInformation
StatusEquals textClosedPositive

Each rule appears in a list with a Remove button. Above the table, a line describes the active rules in words: Conditional formatting: Severity equals Critical (negative); Score greater than 15 (warning); Owner is empty (information); Status equals Closed (positive).

Expected highlighting

Highlighted cells across all 20 entries
ColumnAppearanceHighlighted entries
SeverityNegativeR-02, R-07
ScoreWarningR-01, R-02, R-07, R-11, R-14
OwnerInformationR-04, R-09, R-14, R-20
StatusPositiveR-03, R-08, R-15, R-20

Greater than means strictly greater: R-05 and R-06 score exactly 15 and stay uncolored. R-14 gets two highlights, one for its score and one for its missing owner.

Highlighting is not filtering

The count line still reads 20 of 20 rows. Highlighted rows remain part of the result, and summaries, group totals and downloads ignore color entirely; CSV and XLSX files contain no formatting. Combine the two when you want both: exclude Closed in Filters and 16 entries remain, still highlighted.

When rules overlap

Rules apply in the order you add them, and when two rules match the same cell, the later rule’s color wins. To show a two-level scale on Score, add the broad rule first and the strict rule second:

  1. Score, Greater than, 10, Warning
  2. Score, Greater than, 18, Negative

R-02 (20) and R-07 (25) show Negative; 9 entries from 12 to 16 show Warning. Added in the opposite order, the Warning rule would cover the Negative one.

Keep it readable

Share the highlighting

Conditional formatting is part of a reader’s view. It is not an author default, and Reset view clears it. To keep it, save a personal view. To give it to the team, prepare a shared view: readers choose it in Reader view and choose Apply view. The page always opens without highlighting until a view is applied.

Rule types and messages