Boards

5 min read

With conditional coloring, you can easily apply coloring to cells that meet your defined criteria to visually emphasize or differentiate among the data on your board. This article will cover the basics of how conditional coloring on monday.com works.

Note: The conditional coloring feature is available from the Standard plan and above.

How to locate it

You will find the conditional coloring tool at the top of your board by clicking on the three-dot menu and then the paint tin icon, as shown below. Clicking on it will open the following menu, where you can select your conditions and colors.

BC- Conditional Coloring.gif

Choose a color

Just like with groups and status labels, you can choose the color for your conditional coloring. There is a wide variety of colors to choose from. Select the color you want to use to highlight your data based on the parameters you set.

BC- Conditional Coloring Select Color.gif

Note: The conditional coloring palette is a fixed set of colors. Custom hex colors are not supported. Choose the closest available option if your preferred shade is not listed.

Choose your conditions

Choosing your conditions is simple. First, choose whether you want a specific cell or an entire row (item) to be highlighted. Then, choose the column from your board, the condition, and enter the value. The value can be text or a number. Press Enter, and your formatting will apply.

BC- Set Conditional Coloring (1).gif

Tip: Conditional coloring does not auto-populate values from your board. Type the condition value manually (text or number), then press Enter to apply.

Conditional coloring uses fixed values only. It cannot evaluate dynamic date comparisons such as "before today" or "X days from now." For dynamic date-based coloring, use an automation to change a Status column when the date condition is met, then apply conditional coloring on that Status column.

Note: The Files, Color Picker, Autonumber, and Button columns are currently not supported when using conditional coloring.

Setting conditions on Number or Formula columns

You can apply conditional coloring based on numeric thresholds, such as KPI targets or calculated values. To set a condition on a Number or Formula column, select the column from the column dropdown, then choose a numeric operator (greater than, less than, or equals). Enter your threshold value, and select a color. Press Save to this view to apply.

For example, to highlight rows where a value falls above a target, select your Number column, choose equal to or more than, enter 90, and select color.

Add and delete conditions

You can easily add and delete conditions. To add a condition, choose + Add condition at the bottom of the conditional coloring menu.

BC- Add New Conditional Coloring .gif

To delete a condition, press on the x to the right of the condition that you want to delete.

BC- Delete Conditional Coloring.png

Save as new view

Save your conditional coloring to a new view by first setting your conditions and then choosing the Save as new view button in the upper right-hand corner of the menu:

BC- Conditional Coloring Save New View.png

Note: Conditional coloring rules cannot be saved into an existing view. They must always be saved as a new view. The original view remains unaffected.

Overlapping conditions

If you add multiple conditions, all conditions will apply. You cannot choose to apply one or the other. If you choose two conditions that encompass data that intersect, the last rule you created will be applied and supersede the first.

BC- Conditional Coloring Tooltip.png

For example, if you add the following rule:

BC- First Conditional Color Rule.png

And then add this new rule:

BC- Add New conditional Coloring.png

Your board will look like this:

BC- Conditional Coloring Overview.png

FAQs

Can I color a cell based on a date that is 30 days from today?

No. Conditional coloring supports fixed values only and cannot evaluate dynamic date comparisons. Use an automation to update a Status column when your date condition is met, then apply conditional coloring to that Status column.

Can I save conditional coloring to an existing view?

No. Conditional coloring rules can only be saved as a new view. The existing view you are working in will remain unaffected.

Why can't I find the value I want to set as a condition?

Conditional coloring does not pull values from your board automatically. Type the value manually in the condition field, then press Enter to apply it.

Can I use conditional coloring on a Number or Formula column?

Yes. Select the Number or Formula column, choose a numeric operator (greater than, less than, or equals), enter your threshold value, and select a color.

Can I use a custom color with conditional coloring?

No. The color palette is fixed and custom hex colors are not supported. Choose the closest available option from the palette.

If you have any questions, please reach out to our team right here. We’re available 24/7 and happy to help.