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 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

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

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

    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

    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),""))

    Like
  • What I meant was:

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

    Like
Like Follow
  • 4 yrs agoLast active
  • 7Replies
  • 4359Views