Change colour based on field value?

Tagged: 

Viewing 1 reply thread
  • Author
    Posts
  • September 9, 2022 at 7:18 PM #47948

    Mike Guilbault
    Participant

    Is there a way to change the colour in a field based on the value in the field?

    For example, I have a list of projects with a Due Date. I’d like the Due Date (or background of the field) to turn red if past due.

    Any suggestions?

    September 9, 2022 at 10:57 PM #47952

    Brendan
    Keymaster

    Hi Mike,

    There’s a setting on Number fields to display the value red if it’s negative. But not for Date fields that are past due.

    But you could use a Script field to return an Emoji character that’s red along with some text perhaps such as “OVERDUE ‼️”

    • This reply was modified 1 year, 6 months ago by Brendan.
Viewing 1 reply thread

You must be logged in to reply to this topic.