Agreed. This will make scorecards more effective. Set the value in a Target column, then add a new column for each week’s progress and conditionally format the cell green if it meets or exceeds the Target column and red if it doesn’t. In it’s current form, if you select the Cell option in conditional coloring, it actually applies the logic to the entire column.
I’ve worked with conditional formatting in Monday for all of five minutes and found that this isn’t an option, so super agree with this suggestion. If you manually have to update a value, you might as well update the color of the row yourself. I hope Monday picks this up.
Hello everyone
An alternative to conditional coloring might be to use the Icons app, which enables you to prefix/suffix an icon or any text to an item name based on any condition.
Im wondering if monday.com can give us an update on whether this is a plan moving forward? Conditional coloring certain cells based on another cells data would be tremendously helpful.
Hello, running into the same issue here - this feature would be really helpful! Just wondering if there has been any updates on when we can expect this?
I’m facing a similar issue! I have several number columns, and depending on the value in a “Category” column, the number columns may be either applicable or not.
This makes it difficult to tell if a cell is blank because it hasn’t been completed yet, or if it’s blank because it’s not applicable.
I can’t use “N/A” since the column requires a number, and I can’t add a placeholder value because it would skew the analytical results. Changing the column to text isn’t an option either, as it would also impact analytics.
It would be incredibly helpful to conditionally format a column based on the value in another column—for example, “If Column 1 = X, then set Column 2 to color red.” Even the ability to manually color just that cell would make a big difference.
This feels like a really obvious and necessary feature so I hope this can get on the roadmap ASAP!!