Color That Means Something, Not Just Pretty
Okay. Last lesson we set up highlighting for overdue and paid, so your cells turn red or green depending on what's actually going on. This lesson I want to zoom out for a second, because I want to make sure you understand WHY we've been doing all this, not just how.
Here's my whole opinion, right up front: conditional formatting is worth more than any chart you will ever build. I know that's a weird thing to be opinionated about. But everybody wants the pretty dashboard with the pie graph. And I get it, pie graphs look impressive. Somebody built one for a fundraiser I did once and it was gorgeous and not one single person looked at it. Not one. I checked.
A cell that turns red when you're low on stock does more actual work than that pie chart ever will. Because you don't have to go look for it. It just tells you. That's the whole point of color that means something instead of color that's just pretty.
So let's make color that means something
By now you've got red for low stock and red or green for overdue and paid. Let's add one more layer, because this is where it starts to feel like your spreadsheet is working FOR you instead of the other way around.
Step 1: Pick a number that actually matters to your business.
Not "what number would look nice." What number, if you saw it, would make you go "oh, I need to deal with that today." For a lot of you it's still stock level, but maybe it's a different threshold this time. Maybe it's "any invoice over 30 days" instead of just "overdue." Maybe it's "any order over $500" so the big ones don't slip past you.
Step 2: Select the range.
Same as before. Click and drag over the column or cells you want watching. Not the whole sheet. Just the part that needs the eyeball.
Step 3: Format > Conditional Formatting.
You know this menu now. That's kind of nice, actually, seeing it feel familiar instead of scary.
Step 4: Set your rule and pick a color that means something specific.
This is the part people skip past too fast. Don't just grab red for everything. If red already means "low stock" on this sheet, and now you slap red on "invoice over 30 days" too, you've made two different problems look identical. Your eye can't tell them apart anymore. Use a different color. Orange, maybe, or a different shade. The color itself should be telling you something the second you see it, before you even read the number.
Step 5: Test it on purpose.
Type in a number that should trigger it. Watch it trigger. Type in one that shouldn't. Make sure it stays plain. Don't just assume it's right because it looks right, actually poke at it.
A quick story, because this is where I learned something
My son Blake asked me to help with a school project a while back that needed a chart in it. And I'll be honest, normally he does not want me hovering over his shoulder for anything, let alone an hour. So when he asked, I sat down and I kept it really chill. I didn't over-explain, I didn't turn it into a whole lesson, I just helped him build the thing he needed and let him drive.
And what struck me, after, was that the chart itself wasn't really the point. He didn't need it to be fancy. He needed it to say the one thing his project was trying to say, clearly, so his teacher could see it in two seconds. That's it. That's the same instinct as conditional formatting. You're not decorating. You're making one true thing visible fast.
Sooo when you're picking your rules, ask yourself: if I only had two seconds to look at this sheet, what's the one thing I'd want to jump out at me? Build your color around that. Not around what looks nice in a screenshot.
A real caution here
Don't go overboard with rules. I've seen sheets with eight different conditional formats stacked on top of each other and by the end nothing means anything, it's just a sheet full of Skittles. If everything's highlighted, nothing is. Pick the two or three numbers that genuinely need your attention, color those, and leave the rest alone.
Also, quick practical note: conditional formatting rules can conflict with each other if you're not careful about the order, and it gets confusing to untangle later. Keep a running list somewhere, even just a note in the corner of your sheet, of what each color means and why. Future-you will not remember. I promise you that.
Before next time
Go pick one more number in your own sheet that actually matters to you, something specific to your business, and build a color rule around it. Doesn't have to be complicated. Just has to mean something the second you see it.