Your First Color Rule (and Typing It Backwards)
Okay. New module, and this one's my favorite thing in the entire spreadsheet, no contest.
Conditional formatting. It sounds fancy. It's not. It just means "make this cell change color when something's true." That's it. That's the whole concept.
And I know, I know, everybody wants the charts. The pie graphs, the little dashboards. I get why. They look impressive. But here's my actual opinion, and I'll die on this hill: a cell that turns red when you're low on stock does more real work for your business than any chart you'll ever build. Nobody reads the pie chart on a Tuesday afternoon when they're slammed. But a red cell? You see that walking past your laptop with your hands full. It just tells you.
Let's build one
Go to your product list, the one we set up ugly a few lessons back. Find your "quantity on hand" column.
Highlight that column. Just the numbers, not the header.
Go to Format in the menu bar, then Conditional formatting. A panel opens on the right side.
Under "Format cells if," click the dropdown. You want "Less than." Then in the box below it, type your number. Let's say anything under 5 units is your danger zone. Type 5.
Pick a color under "Formatting style." I like the red one, obviously, because red means stop and look at me.
Click Done.
Sooo. If it worked, any product with fewer than 5 units on hand should have gone red. Go check. If nothing changed, don't panic, we're gonna talk about that in a second.
The story I have to tell you
First time I ever demoed this live in front of a room, the whole column turned red. Every single row. All of it, screaming red, like I'd set the building on fire.
I'd typed the rule backwards. I put "greater than 5" instead of "less than 5," so basically everything above zero qualified. I just laughed and told the room, "sooo that's what NOT to do," and fixed it right there in front of everyone. Changed the dropdown, hit done, and half the reds disappeared like nothing happened.
That mess-up got a bigger laugh than anything I'd planned all day. People remember the fix more than the perfect version. Honestly I do it on purpose now sometimes. Okay, not on purpose. But I don't panic when it happens, because it happens to everybody, and watching me un-break it is more useful than watching it work right the first time.
So if your column doesn't turn red, or it ALL turns red, check your dropdown. "Less than" and "greater than" look like nothing when you're moving fast, and they do opposite jobs.
Making it useful, not just pretty
Once the basic rule works, you can do a second one. Maybe yellow for "getting low, keep an eye on it," red for "order now." Same steps, just a second rule stacked on top with a different number.
But don't go build six colors for six situations on your first try. Get the one red rule working right, actually use it for a week, see if it's telling you true things. Then add more. Build it ugly and functional first, fuss with the extra colors later. You've heard me say that before and I'm gonna keep saying it.
The kitchen thing
This whole idea, color that means something instead of just looking nice, it's kind of the same instinct I use hosting game night at my house. We had eleven people crammed in my kitchen one time, way more than fit, and honestly I wasn't worried about whether the snacks matched the theme or the chairs looked cute. I was watching who didn't have a seat yet, who looked a little lost, who needed a plate handed to them. That's the whole job. Not making it pretty. Making sure the right thing gets noticed by the right person at the right moment.
Your spreadsheet's the same. The red cell is you, handing yourself a plate before you even knew you needed one.
A quick real caution
If you're sharing this sheet with anyone else, warehouse staff, a business partner, whoever, make sure they know what red means before they see it. I've watched people panic over a red cell that just meant "reorder soon," not "we are out of business." Takes ten seconds to tell them. Saves you a frantic phone call.
And remember, share a copy with people, not your master sheet. Somebody will "fix" your conditional formatting rule by accident and you won't know until it's all red again and this time it's not a joke.
---
Before next time: Get one color rule working on your own quantity column, even if you typo it backwards first like I did. Actually especially if you do, that's the fastest way to learn what the dropdowns actually mean.