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.

7 replies

null
    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    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

    • matt_braunstein
    • 5 yrs ago
    • Reported - view

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

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view
    • matt_braunstein
    • 5 yrs ago
    • Reported - view

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

    • Support
    • 5 yrs ago
    • Reported - view

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

    • matt_braunstein
    • 5 yrs ago
    • Reported - view

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

    • matt_braunstein
    • 5 yrs ago
    • Reported - view

    What I meant was:

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

Content aside

  • 5 yrs agoLast active
  • 7Replies
  • 4621Views