Color Cells or Text Based on Conditional
M

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.

Ninox Profile

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

M

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

Ninox Profile

https://ninoxdb.de/en/whatsnew

M

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

Ninox Profile

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

M

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

M

What I meant was:

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

Reply