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.
| Ref | Type | Description | Owner | Severity | Status | Due | Score |
|---|---|---|---|---|---|---|---|
| R-01 | Risk | Payment provider contract lapses before renewal | Dana Kim | High | Open | 2026-11-20 | 16 |
| R-02 | Issue | Nightly backup job failed twice | Omar Haddad | Critical | Open | 2026-11-05 | 20 |
| R-03 | Action | Update supplier contact list | Grace Liu | Low | Closed | 2026-10-30 | 4 |
| R-04 | Risk | Key engineer on extended leave in December | (blank) | Medium | Open | 2026-12-01 | 12 |
Show all 20 rows
| Ref | Type | Description | Owner | Severity | Status | Due | Score |
|---|---|---|---|---|---|---|---|
| R-01 | Risk | Payment provider contract lapses before renewal | Dana Kim | High | Open | 2026-11-20 | 16 |
| R-02 | Issue | Nightly backup job failed twice | Omar Haddad | Critical | Open | 2026-11-05 | 20 |
| R-03 | Action | Update supplier contact list | Grace Liu | Low | Closed | 2026-10-30 | 4 |
| R-04 | Risk | Key engineer on extended leave in December | (blank) | Medium | Open | 2026-12-01 | 12 |
| R-05 | Issue | Customer export emails delayed | Omar Haddad | High | Monitoring | 2026-11-12 | 15 |
| R-06 | Action | Rotate shared service account password | Dana Kim | High | Open | 2026-11-03 | 15 |
| R-07 | Risk | Data center migration overlaps peak season | Felix Wagner | Critical | Open | 2026-12-15 | 25 |
| R-08 | Issue | Duplicate invoices for three customers | Grace Liu | Medium | Closed | 2026-10-28 | 9 |
| R-09 | Action | Review vendor security questionnaire | (blank) | Medium | Open | 2026-11-06 | 8 |
| R-10 | Risk | Office lease decision delayed | Felix Wagner | Low | Monitoring | 2027-01-15 | 6 |
| R-11 | Issue | Mobile app crash on older devices | Omar Haddad | High | Open | 2026-11-18 | 16 |
| R-12 | Action | Publish incident review | Dana Kim | Medium | Open | 2026-10-31 | 10 |
| R-13 | Risk | Single supplier for replacement laptops | Grace Liu | Medium | Monitoring | 2026-12-10 | 12 |
| R-14 | Issue | Support queue above target for two weeks | (blank) | High | Open | 2026-11-13 | 16 |
| R-15 | Action | Test disaster recovery runbook | Felix Wagner | High | Closed | 2026-10-20 | 15 |
| R-16 | Risk | New privacy regulation affects sign-up flow | Dana Kim | Medium | Open | 2027-02-01 | 9 |
| R-17 | Action | Confirm holiday on-call coverage | Omar Haddad | Low | Open | 2026-11-25 | 4 |
| R-18 | Issue | Search results stale after reindex | Felix Wagner | Medium | Open | 2026-11-02 | 12 |
| R-19 | Risk | Budget approval for monitoring tools | Grace Liu | Low | Open | 2026-12-20 | 6 |
| R-20 | Action | Archive retired project spaces | (blank) | Low | Closed | 2026-10-15 | 2 |
Step 1: Add the rules
- Open Saved views and presentation, then Conditional formatting.
- Set Format column to Severity, Condition to Equals text, Comparison value to
Criticaland Appearance to Negative. Choose Add formatting rule. - Add three more rules the same way:
| Format column | Condition | Comparison value | Appearance |
|---|---|---|---|
| Severity | Equals text | Critical | Negative |
| Score | Greater than | 15 | Warning |
| Owner | Is empty | None needed | Information |
| Status | Equals text | Closed | Positive |
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
| Column | Appearance | Highlighted entries |
|---|---|---|
| Severity | Negative | R-02, R-07 |
| Score | Warning | R-01, R-02, R-07, R-11, R-14 |
| Owner | Information | R-04, R-09, R-14, R-20 |
| Status | Positive | R-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:
- Score, Greater than,
10, Warning - 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
- Color should never be the only signal. Keep the meaning in the cell text, such as Critical or Closed, and rely on the rule description line for readers who cannot distinguish the backgrounds.
- The four appearances use Confluence table cell background colors. Check contrast in the light or dark theme your readers use.
- Prefer a few rules with distinct meanings over many shades. A view can hold up to ten rules.
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
- Contains text and Equals text ignore case. Greater than and Less than compare numbers using the column’s number format. Is empty and Is not empty need no value.
- Enter a value for this formatting rule. appears if the comparison value is missing, and Enter a valid number. if a number rule has text such as “high”.
- Use at most ten conditional formatting rules. appears when you try to add an eleventh.