Conditional Formatting Column

The “Conditional Formatting” column would work like conditional formatting in Excel. It is a very powerful way to use color to add meaning to numbers. The basic idea is to modify the color of a cell based on it’s value. For example, if the value is <= X make the cell red. If the value is > x make the cell green. It would be configured with a wizard-like interface, likely similar to the “Formula” column.

4 Likes

I would LOVE this! I would like the Conditional Formatting to work with finding specific text in a pulse.

1 Like

That would be amazing! But I would be happy if it was a self contained column - at first.

Bumping this one, as I’ve just thought about the same thing on one of my boards.
And not just for number columns, but dates as well (e.g. color-coding older tickets before date X).

Ideally, any conditional formatting should optionally also be possible to make it applicable to the entire row, instead of just the cell.

3 Likes

Agree, would be a great feature to have.

Not just conditional formating, but many other options for formula column. I am sure that you are working on it. Would love to see best practices page for using formula column. I would be happy to share mine and learn what can I do with it.

Would be really useful to traffic light. We use risk scoring a lot so 0-9= green, 10 to 19 = amber, 20 to 25 = red.

It would be a great addition so we can intuitively deal with large sets of data

The new feature for Conditional formatting is great, but is it really necessary to have to create/save a whole new View in order to save the formatting? @Julia-monday.com
/Johan

1 Like

Hi @johan.n

Yes, this is the way the feature is currently built!

What would you prefer to see?

CC: @danaaviv

I’d just want to apply the formatting to an existing view that I’m using e.g. “Main table”. Not possible?

1 Like

We’d love for you to fill out this feedback here as well if you can :slight_smile: https://forms.monday.com/forms/d8e7ee98c6f6be5256a175fae1e6a2da

1 Like

Hey @Julia-monday.com!

I would absolutely love to save my conditional color formatting to the main table view :pray:
I submitted a bug report before realizing that is how the feature is built, then I submitted a feedback form.

I think it would improve the functionality of the feature 10x!

Let me know if this becomes possible!

Thank you,
Matt

5 Likes

All of these features are great. I implemented conditional formatting on one of our boards and I really would love to see this being implemented in all our product backlog boards.

Having more then over 50 product backlog boards I find myself having a day job to keep all out boards the same after every new feature release. Keeping them the same is important to have the same workflow in every board.

To keep up with features like conditional formatting in our workflow it is important to have something as a master board Set Board as MASTER Board (Column Structure, Permissions, and Automations Applied Across Linked Boards). Worhout this it is to time consuming to add changes

1 Like

+1 on being able to save these to the Main Board view. This feature is useless to us otherwise, because no one ever remembers to go to a custom view if there isn’t a reason to have one.

2 Likes

@zlanich You can set the custom view to be the default one the board is loaded on, so people do not have to manually choose it every time the go there. But I do agree it should just be possible to save it to the main board view as well, as I do not see the point of the way they have chosen to do it now.

Yea, that’s what we’re doing right now. The confusion comes into play when people don’t realize I’ve created a custom view, and I have to constantly tell everyone in the company to switch to the custom (new default) view.

Hey all, thank you for your feedback!

Happy to hear that the conditional coloring feature is working well but we’ll be sure pass this along to our product team for consideration as I do see its value for the main table.

Thanks again and keep the feedback coming!

Cheers :slight_smile:

I would like to set conditional colouring based on a status column i.e. if Status is No colour the items in that row

I would love for the conditional formatting rules that are set to carry over to the dashboards when the list view is used. OR at a minimum that you could add conditional formatting on the dashboards.

1 Like