0

Color Cells or Text Based on Conditional

I would like to see the ability to alter the color of a cell or text in a cell based on a conditional statement. This capability exists for a list, but not for a numerical or text field.

7replies
{{batchActionsCtrl.state.selectedCount}} {{batchActionsCtrl.state.selectedCount==1?'reply':'replies'}} selected Move Cancel
Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • You can use a function field f(x) for this. The Formula:

    styled ("Text","Background","Font colour","icon") e.g. styled("my Text", "#ddeeff", "green", "dialog")

    Leo

    Reply Like
  • Thanks! I don't see this function in the user manual. Is this a new function?

    Reply Like
  • Is there any plan to expand this ability to numeric cells?

    Reply Like
    • Support
    • Support
    • 4 yrs ago
    • Reported - view

    For a "non text field" you can use styled(text(non_text_field),"green"...) - Best regards, Jörg

    Reply Like
  • I would like to color the numbers in a numeric field. This does not work. The following is what I tried.

    number(styled("a",color(255,255,255),color(150,0,0),""))

    Reply Like
  • What I meant was:

    number(styled("123",color(255,255,255),color(150,0,0),""))

    Reply Like
  • Spam
    • Remove post
    • Remove and block user
  • Edit
  • Publish
  • Unschedule
  • Cancel event
  • Uncancel event
  • Set status
    • Clear status
  • Pin
  • Unpin
  • Bump
  • Open replies
  • Close replies
  • Clear flags
  • Move
    • Move to category:
    • Learn & Share
    • Get help
    • Webinars
  • Copy
    • Copy to category:
    • Current category
    • Learn & Share
    • Get help
    • Webinars
  • Change type
    • Change topic type to:
    • Discussion
    • Question
    • Idea
    • Issue
    • Article
    • Event
  • Restore post
    • Spam
    • Offensive
    • Inappropriate
    • Duplicate
    • Other
  • Remove post
    • Spam
    • Offensive
    • Inappropriate
    • Duplicate
    • Other
  • Publish
  • Spam
    • Remove post
    • Remove and block user
  • Edit
  • Pin
  • Unpin
  • Open replies
  • Close replies
  • Label
    • Clear label
  • Move
  • Clear flags
  • Restore post
    • Spam
    • Offensive
    • Inappropriate
    • Duplicate
    • Other
  • Remove
    • Spam
    • Offensive
    • Inappropriate
    • Duplicate
    • Other
Like Follow
  • 4 yrs agoLast active
  • 7Replies
  • 4384Views