Forum Discussion

MikeBlinkhorn1's avatar
MikeBlinkhorn1
Qrew Trainee
8 years ago

I need a duration field background to change color based on duration number

I have a duration field that calculates the number of days old, based on if another field (status) is not set to "closed". I would like that fields background to change to red if the duration is more...
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
You will need to use a formula-rich text field to add the styling you would like.

The dates will need to be converted ToText() and then you can use a span or a div to highlight as desired.