How to Do Conditional Formatting in Tableau

Tired of your Tableau dashboards looking like a giant wall of numbers? Conditional formatting is the simplest way to make your data talk, instantly showing you what’s working, what needs attention, and where your best opportunities are hiding. A single rule can transform a confusing table into a clear, actionable report.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

This tutorial will walk you through exactly how to add conditional formatting in Tableau, from the simple drag-and-drop essentials to more customized setups using calculated fields. We'll cover several practical methods you can use today to make your visualizations more effective.

What is Conditional Formatting, Anyway?

Conditional formatting automatically applies specific formatting - like colors, shapes, or sizes - to your data based on rules you define. Think of it as a set of visual cues that direct your audience's attention to the most important information on the screen. It works like a traffic light for your data: green means good, yellow means 'take a look,' and red means stop and investigate.

For example, you can use it to:

• Highlight all sales figures below your target in red.
• Display an upward-pointing green arrow next to products with positive profit margins.
• Color-code regions based on their performance tier: "Gold," "Silver," or "Bronze."

This simple technique saves time for both the creator and the viewer, ensuring that key performance indicators (KPIs) and critical insights don't get lost in a sea of data.

Method 1: The Quick and Easy Way with the Marks Card

The most direct method for applying conditional formatting in Tableau is by using the Color property on the Marks card. This technique works perfectly for visualizing measures along a continuous color gradient, like low sales to high sales.

Let's use a simple example: a text table showing Sales by Sub-Category. Our goal is to color the sales figures so that high values are green and low values are red.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step-by-Step Instructions:

1. Build a Basic Text Table

First, create a simple table to work with. Drag a dimension, like Sub-Category, to the Rows shelf. Then, drag the measure you want to evaluate, such as Sales, onto the Text mark in the Marks card.

You should now have a simple one-column table listing sub-categories and their corresponding sales totals.

2. Drag Your Measure to the Color Mark

This is where the magic happens. Drag that same measure (Sales) from the Data pane and drop it directly onto the Color mark in the Marks card. Instantly, Tableau will apply its default color gradient to the numbers in your table. By default, it uses a greyscale where lighter shades represent smaller numbers and darker shades represent larger ones.

We're making progress, but a simple grey gradient isn't very at-a-glance. Let's make it more intuitive.

3. Edit the Colors and Set the 'Rules'

To customize the colors, click on the Color mark, then click Edit Colors. This opens a dialog box where you can control the entire color scheme.

• From the Palette dropdown, choose a more meaningful palette. The Red-Green Diverging palette is a classic choice for performance metrics.
• Check the Stepped Color box and set the number of steps to 2. This creates two distinct color groups instead of a smooth gradient, making it easier to see what’s above or below our pivot point.
• Finally, click Advanced. Here you can set the Center value. Let's set it to something like $150,000. Now, any value above this center point will be green, and any value below it will be red.

Hit "OK" and you're done! Your table now clearly shows which sub-categories are performing well and which are lagging, all with intuitive color coding.

Method 2: Gaining More Control with Calculated Fields

What if you need more precise control than just a simple "high" vs. "low" gradient? Let's say you want to define specific performance categories like "Great," "Okay," and "Poor" based on your own business logic. This is where calculated fields come in.

By creating a calculated field, you can set custom rules using IF/THEN logic to bucket your data exactly how you want it. Let’s create a field to categorize product sub-categories based on their profitability.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step-by-Step Instructions:

1. Create a Calculated Field

In the Data pane on the left, right-click and select Create Calculated Field. Let's name this calculation "Performance Tier".

In the formula box, we’ll use an IF/THEN/ELSEIF statement. We want to say:

• If Profit Ratio is greater than 10% (0.1), then it’s “Great”.
• If it's between 0% and 10%, it’s “Okay”.
• If it’s negative, then it's “Poor”.

Our formula will look like this:

IF SUM([Profit]) / SUM([Sales]) > 0.1
THEN "Great"
ELSEIF SUM([Profit]) / SUM([Sales]) >= 0
THEN "Okay"
ELSE "Poor"
END

Click "OK" to save your new field. You'll see it appear in the Data pane as a new dimension.

2. Apply the Calculation to Your View

Now, build your view again with Sub-Category on Rows and Sales on Text. This time, instead of putting the Sales measure on the color mark, drag your new Performance Tier calculated field onto Color.

Tableau will automatically apply distinct colors to each of your new categories ("Great," "Okay," and "Poor").

3. Assign Meaningful Colors

Tableau’s default color choices might not be what you want. To change them, click the Color mark, and you’ll see your new performance categories in the legend. To change the color for “Poor”, for example, double-click the item in the legend and select a strong red. Assign a nice green to "Great" and a neutral yellow or grey to "Okay".

This method gives you complete control to define your business rules and create discrete, clearly understood performance indicators that a simple two-color gradient can’t.

Method 3: Using Shapes and Icons as KPI Indicators

Sometimes color isn't enough, especially on a busy dashboard. Using shapes as KPI indicators — like up/down arrows or checks/crosses — can provide a powerful visual punch.

Let's add KPI arrows to our table to indicate whether a sub-category is profitable or not.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step-by-Step Instructions:

1. Change the Mark Type to 'Shape'

On the Marks card dropdown menu, which is likely set to 'Automatic,' change it to Shape. You’ll notice the Text and Color properties are still there, but a new Shape property has appeared.

2. Create a Calculated Field for the Shape Logic

Just like our last method, we need a calculation to tell Tableau which shape to display. Let's create a new calculated field named "Profit Indicator".

The logic is simple: if the sum of profit is positive, we'll label it "Profitable." Otherwise, it's "Unprofitable."

IF SUM([Profit]) > 0
THEN "Profitable"
ELSE "Unprofitable"
END

3. Add Both Shape and Value to the View

Start with Sub-Category on Rows. Now, drag your SUM(Sales) pill to the Text on the Marks card. Next, drag your new Profit Indicator calculated field onto the Shape property in the Marks card.

4. Map Your Custom Shapes

Now to assign the right icons. Click on the Shape mark itself. In the legend that appears, you can assign a shape to each value from your calculation ("Profitable" and "Unprofitable").

• Select the "Profitable" data item and choose a shape. From the Shape Palette dropdown, find the "KPI" palette, then select the green upward arrow.
• Select the "Unprofitable" item and assign the red downward arrow.

Click "OK." Now you have clear, intuitive indicators of performance!

Bonus Tip: Combine Shapes and Color for Maximum Impact

To really make your KPI indicators stand out, you can color them conditionally too. Simply drag your same Profit Indicator calculated field onto the Color mark as well. Then edit the colors to match the shapes: green for "Profitable" and red for "Unprofitable." This dual formatting makes your results impossible to misinterpret.

Quick Tips for Effective Conditional Formatting

• Less is More: Avoid making your dashboards look like a Christmas tree. Use a limited, intentional color palette. Often, one or two accent colors against a neutral background is most effective.
• Consider Accessibility: About 8% of men are colorblind. The classic red-green combination can be hard for them to distinguish. Consider using a blue/orange palette or adding shapes and labels to ensure everyone can understand your data.
• Use Tooltips for Detail: The formatting should draw attention, and the tooltip should fill in the details. Customize your tooltips to show the exact numbers and context when a user hovers over a mark.
• Be Consistent: If you use green to represent positive profit on one dashboard, don't use it to represent high costs on another. Consistency across your reports builds trust and reduces the cognitive load for your users.

Final Thoughts

Tableau’s conditional formatting transforms dense tables and charts into digestible stories. Whether you use the simple color mark, calculated fields for custom logic, or shapes for KPI indicators, these techniques help you guide your audience directly to the most important business insights in your data.

While mastering these techniques in powerful tools like Tableau is rewarding, sometimes you need insights now, without spending an afternoon creating formulas and adjusting menus. That’s where we felt the friction. With Graphed you simply connect your data sources and ask questions in plain English — like "Show my weekly sales, highlighting any campaigns that spend a lot but have low revenue" — to get a real-time dashboard built for you instantly. Instead of building the report, you get to focus purely on the insights.