How can I rename the values in a RAG column while keeping the colour styling using SetCellStyle?

Options
Maudleen J
Maudleen J Member
in Product documentation

Hi everyone,


I’ve created a RAG-style column in my Aperture workflow using SetCellStyle, and it’s working well in terms of applying colours (Red, Amber, Green) based on a percentage field.
However, the values currently display as True or False, and I’d like to rename them to custom labels like "Pass", "OK", or "Fail" — without losing the colour formatting.

image.png


Is there a way to do this within the SetCellStyle function? Ideally, I’d like to show the custom label and keep the background or text colour applied.


Here’s an example of what I’m trying to achieve:
0–50% → Fail (Red)
51–75% → OK (Amber)
76–100% → Pass (Green)


Any help or examples would be much appreciated!

Thanks

Answers

  • Josh Boxer
    Josh Boxer Administrator

    Something like this:

    image.png

    Though actually the Conditions are checked in order, top to bottom, so you could have Less than 51, Less than 76, Else Pass (Green)

Categories