I love color-coded & conditional spreadsheets but many who can’t read them, “don’t get it,” or the color is distracting, they can’t filter for color or they are unable to cluster or follow data via color comparisons. Or they’re just *sses.
I get an actual dopamine high every year when I have to recreate and update the Bracket Tracker for Evo, which is a spreadsheet that tracks all 1200-ish brackets, the 300+ judges working on progressing them, and the status of each and every one over all three days.
It's a useful feature, but with collaborative spreadsheets it starts breaking down for some reason as rows are added and deleted by different people. In complicated spreadsheets, you'll have these disconnected rules that selectively affect islands of cells and skip over others.
when i graduated the first thing i did was make a giant spreadsheet with conditional formatting to track all my spending + account balances in real time, faster than even my banking app
Comments
The descent into the dark side feels inevitable.
It's everything I always wanted a spreadsheet to be able to do.
still going strong 5 years later