Tone
A five step ramp.
One column, five tints. Strict to soft. Or paint a single tone and lean on bold for the highlight.
Cell Formatting
Cells that read themselves.
Set a rule. The cell paints itself.
Activity by hour
5 rules · 1 column| Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
|---|---|---|---|---|---|---|---|
| Hour 9 | 12 | 24 | 31 | 48 | 62 | 18 | 6 |
| Hour 11 | 22 | 38 | 44 | 58 | 76 | 30 | 10 |
| Hour 13 | 34 | 52 | 60 | 72 | 88 | 42 | 16 |
| Hour 15 | 44 | 64 | 70 | 84 | 96 | 56 | 24 |
| Hour 17 | 28 | 46 | 56 | 68 | 80 | 38 | 12 |
Rules
- value ≥ 80first match wins
- value ≥ 60first match wins
- value ≥ 40first match wins
- value ≥ 20first match wins
- elsefirst match wins
The order
Strict first, loose last.
Rules read top to bottom. The first match wins. The rest stay calm.
cell ≥ 80apply
cell between 40 80apply
cell emptyapply
Per column
A rule lives, with the column.
Move the column, the rules move. Sort the column, the colors stay glued to the values they describe.
- Predicates from greater than to between, contains to empty. Numbers and text behave the same way.
- Style controls stay light: background, text color, bold. The value still leads.
- Live preview chip beside every rule, so the colour you pick shows before you save.
The motions
Three knobs, any signal.
Pick a tone, pick a check, pick the type. The whole column reads at a glance.
greater thangreater equalless thanless equalequalnot equalbetweencontainsemptynot empty
Predicates
Ten checks ship.
Comparison for numbers. Contains for text. Empty and not empty for the in between. Combine in any order.
12385672886422
Type
Heatmap, instantly.
One column with a numeric ramp turns into a heat strip. The eye finds the peak before the head finds the row.
Together
Color the meaning, skip the legend.
10
predicates per column
∞
rules per column
BG · FG · B
three style knobs
A reader scanning a heatmap reaches the answer before scanning the values. The column does the reading. Your reader does the deciding.
In short
Questions, answered.
How many rules per column?+
As many as you need. The first rule that matches wins, so order them from strict to loose.
Which checks ship?+
Greater, less, equal, between, contains, empty, and not empty. Numbers and text both supported.
Can rules carry fonts?+
Background, text color and bold. Style stays light so the value still reads.
Does sort respect rules?+
Yes. The cell keeps its color when you sort or search. The rule travels with the data.