Help with Setting Up Conditional Formatting in Grist

[kirikon_owube]

Hi everyone…

I am new to Grist and loving its flexibility so far! Although, I am struggling to set up conditional formatting for one of my tables. I want a specific column to change its background color based on the values (e.g., green for “Completed,” yellow for “In Progress,” and red for “Pending”).

I also check this: https://community.getgrist.com/t/small-help-with-upvote-on-improving-grist-module-on-maksalesforcedeveloper But I have not found any solution. Could anyone guide me about this? I have checked the documentation and tried a few formulas, but I can’t seem to get it right. Could someone guide me through the steps or share an example formula for this?

Thanks in advance for your help!

Respected community member!

[natalie-grist]

Hi there,

In the ‘Column’ tab of the Creator Panel (right-hand side of the page), click ‘Add Conditional Style’.

Because you want to match a specific string in the column, we use double quotes to specify this in our conditional formula. In this example, I want to change the formatting based on the value in the Status column. You said you want to make the fill color green when Status is “Completed” so the formula is $Status == "Completed". Then, click the ‘Cell Style’ box and select your fill color.

Thanks,
Natalie