HubSpot Update: Conditional formatting in table visualizations within custom reporting

Okay.

So Let's talk about this HubSpot update.

That has everyone buzzing. It's like

Someone gave our data dashboards a serious upgrade.

You know how it is. Yeah. Sometimes you're just drowning in spreadsheets.

Just a sea of numbers. It's impossible to see the forest for the trees. It's the

data overload dilemma. Right? Exactly. We've all been there. You Being

the data wiz you are.

You send over these 2 HubSpot

articles, both from October

2024,

about their new conditional formatting for tables.

And let me tell you

This is huge e Huge. For anyone who wants to actually use their data.

To make smarter decisions faster.

It's about transforming those walls of data into Dynamic visual stories. They practically tell you what to do next.

Okay. For

anyone who hasn't had their coffee yet this morning Break

it down for us. What's the magic behind conditional formatting?

Imagine this. You're looking at your sales numbers for the month.

Instead of just seeing a jumble of figures, what if the highest performing deals lit up in green?

While those needing attention were flagged in red

That's conditional formatting in action.

It's like your data is finally speaking your language.

No more squinting at spreadsheets.

Trying to decipher the code?

Precisely. It's about setting rules that automatically format cells based on their values.

So you instantly see the outliers, the trends, the insights that matter most.

No more hunting for needles in a haystack.

And both of these articles from October 9th 10th emphasize this isn't just about highlighting big wins.

You can use this for currency values, percentages, even durations.

Absolutely. Let's say you're analyzing marketing campaign data.

You could use conditional formatting to instantly see which campaigns had the longest average engagement times. Maybe highlighted in a gradient from cool blue to attention grabbing yellow.

Suddenly, you know exactly which content is resonating most with your audience.

It's like having a data spotlight.

Illuminating the key takeaway so you don't have to connect the dots yourself.

And from what I'm seeing, HubSpot isn't limiting this power to just one tool.

They're rolling it out across their whole platform.

You got it. Marketing hub, sales hub, service hub.

You name it. If there's a table involved

There's a good chance you can bring it to life with conditional formatting.

So no matter what part of HubSpot you're in, this update is here to make your life easier, your reports more impactful, and your insights impossible to ignore.

Exactly. This isn't just a cosmetic tweak.

It fundamentally changes how you interact your data.

It's about making data analysis less about crunching numbers and more about uncovering opportunities and making smarter decisions.

And speaking of smarter decisions, let's talk strategy.

Because the real power of conditional formatting lies in knowing how to use it effectively. Right?

You hit the nail on the head.

It's like having a whole tool chest at your disposal. The real skill is knowing which tool to use when.

Okay. So let's talk about putting this power into practice.

The October 10th article had a bunch of screenshots showing how it all works.

What are the first steps our listener needs to take?

To unleash this conditional formatting magic.

It's surprisingly intuitive, actually. Let's say

you're in the custom report builder.

You build your table visualization just like you normally would.

Standard stuff so far.

So where is the secret entrance to conditional formatting land?

Keep an eye out for the chart settings section.

That's where the fun begins.

You'll see a conditional formatting section.

Where you choose which column you wanna transform.

And I'm guessing this is where you'd tell HubSpot.

What kind of data you're working with?

Numbers, percentages, all that good stuff.

Exactly.

HubSpot lets you apply this to all sorts of data types.

Numbers, currency, percentages.

Even those tricky duration fields.

And get this, you get to choose from 10 different color palettes.

Okay. Color palettes, now we're talking.

Are we talking gradients?

You got options.

Yeah. Interesting colors.

What kind of visual masterpieces can we create here?

You can keep it simple with HubSpot's automatic color gradient.

Which is pretty slick.

Or you can really take the reins and define your own custom colors for the minimum and maximum values.

I love that level of control.

It's like having a designer on speed dial.

But for your data?

And what about those midpoints the articles mentioned?

How do those factor in?

Oh, the midpoints.

Think of them as your secret weapon for adding even more nuance to your data story.

Let's say you're using a gradient that goes from green to red.

To show performance.

By default, HubSpot intelligently chooses a midpoint color for you.

But you can override that and pick your own middle color.

To highlight a very specific value range.

So if you really wanna draw attention to a specific performance threshold

The midpoint is your tool.

Exactly. It's all about making your insights pop visually.

So no one misses the point.

Okay. I'm hooked.

I've got my color palette.

My midpoints are strategically placed.

What's next in this conditional formatting journey?

Now it's time to set the stage for your data drama.

You get to define the range for your conditional formatting.

HubSpot's pretty smart.

It'll automatically set minimum and maximum values.

Based on the data in your table.

Which is great for a quick overview.

But what if you need to be more laser focused?

Say, you only wanna highlight values above a certain target.

That's crucial to hitting your quarterly goal.

That's where manual control comes in.

HubSpot lets you set specific minimum and maximum values.

So you're only seeing the data that truly demands your attention.

No more distractions, just pure actionable insights.

That's what I'm talking about.

And just to be sure I'm following.

You can apply this conditional formatting magic to multiple columns at once. Right? Absolutely. It's not a one and done situation.

Imagine one column with sales numbers in shades of green and red.

While another uses a blue to yellow gradient to represent customer satisfaction.

Suddenly, you're seeing correlations and trends that were hidden in plain sight before.

Now you're talking my language.

The October 10th article had a great example of this.

They used a marketing email report, and it was like a night and day.

Multiple columns, each highlighting different metrics with color coded clarity.

It's about making your data tell the story you need to tell.

And speaking of stories

The articles briefly mention how to handle duration based data

which can be a bit tricky to visualize.

How does HubSpot wrangle that?

It's pretty clever, actually.

When you're working with durations, HubSpot lets you choose the time measurement for your minimum, midpoint, and maximum values.

So whether your data is in seconds, minutes, days

Or even weeks, that color gradient will accurately reflect the time scale that matters most to you.

It's like HubSpot knows we need options.

To wrangle all the different flavors of data out there.

And speaking of options, what if you go through all this

Get your conditional formatting just right

and then realize, oops, I need to tweak this.

Can you go back and easily reverse or modify those settings? Absolutely. HubSpot wouldn't leave you hanging like that.

You just select the column.

Tweak your settings to your heart's content.

Or if you wanna start from scratch, there's a remove conditional formatting button.

Right there in the chart settings.

Flexibility and control. It's a beautiful thing.

And, honestly, that's what makes this update so powerful.

It's not just about making data prettier.

It's about making it work for you. Sweet. It's great. It's true. This update really is about putting you back in the driver's seat when it comes to data analysis.

Yeah. Is it?

HubSpot gave us the keys to a high powered sports car.

It's not just about getting from point a to point b anymore. It's about enjoying the ride, feeling the wind in your hair Okay. As you navigate those insights.

I like where your head's at with that analogy.

And it speaks to the bigger picture here.

Conditional formatting isn't just about making spreadsheets less intimidating.

It's about unlocking a whole new level of data literacy.

Yeah. And isn't that what it's all about?

Because knowing how to find and interpret the right data

It's essential in any business today. Absolutely.

It's like Remember back in

the day when only a select few knew how to read?

Suddenly, knowledge and power became accessible to everyone once literacy became widespread.

I think we're on the verge of something similar with data. It's a powerful thought. So Tools like conditional formatting. They're like our gateway to data literacy.

Exactly. They empower everyone to understand and use data effectively, not just the analysts in the backroom. As we wrap up this deep dive into the colorful world of conditional formatting

What's the one thing you want our listener to walk away thinking about?

Don't just collect data, interrogate it. Make it tell your story.

HubSpot's given you a powerful new tool with conditional formatting.

Use it to uncover hidden opportunities.

Make smarter decisions.

And ultimately, drive better results.

I love it. It's about taking control of your data destiny.

And for our listeners, if you wanna see these conditional formatting tricks in action screenshots, Step by step guides will have links to both HubSpot articles in our show notes.

Until next time. Keep exploring, keep asking questions, and keep diving deep into the fascinating world of data.