List Cell Color Based on the Value

Legacy Contributor

I am trying to set a cell color in a list dependent on the cell's value using Config Console. I have tried something similar to the below but with no luck.

 

Is it possible to set the cell's color based on the the value in that cell? 

 

Example:

Display Fields

       RelationshipStatus

               color of red when RelationshipStatus = "TermFinal" 

               color of green when RelationshipStatus = "Active"

               color of yellow when RelationshipStatus = "TermPending"

cleverly

The only way I know of to accomplish this is to use the display as tag option. And it will require a simple condition, so you won't be able to do a string compare directly in the UI LPL. If you added your own user defined condition fields that did the comparison, then you could do:

Display Fields
    RelationshipStatus
        display as tag
            color of red when (IsTermFinal)
            color of yellow when (IsTermPending)
            color of green when (IsActive)

With these user defined condition fields:

Conditions
    IsTermFinal
        when (RelationshipStatus = "TermFinal")

    IsTermPending
        when (RelationshipStatus = "TermPending")

    IsActive
        when (RelationshipStatus = "Active")

0911060553270289.pdf