How to display column values in colours

[#1]

Hi,

I have a expression in straight table as below

DueDays= = today()-aggr(Date(max(DateDue)),ID)

and the values in that column are

1,975

2,098

1,897

-20

-13

-21

and so on

I would to show The minus values with RED colour and the rest with BLACK. Is this possible?

Thanks.

[jerem1234]

Yep, check the + next to your expression, then under Text Color, put an expression like:

if(DueDays<0, red(), black())

Hope this helps!

[#3]

Thanks and I need to show the RED colour as VERY Dark RED is it possible?

[simondachstr]

Get the RGB code for your DARK red and replace red() with RGB(redval,yellowval,blueval)

[#5]

Thanks. I don't have RGB code for DARK red that is my problem.how to do this?

[jerem1234]

Yep thats possible, you can use the rgb() function instead of red(). So find the rgb values for the color you want then fill them in the rgb function:

For example:

rgb(100,100,100) will show grey.

Hope this helps!

[#7]

How can I get rgb() for DARK red as I don't have the code

[jerem1234 · Accepted solution]

to find the rgb value, you can go to color tab and click one of the colors and then in the next window, click the window again. Then you can play around and see what colors give what rgb value (which is shown on bottom right as Red, Green, Blue).

A dark red color is:

rgb(140,0,0)

Hope this helps!

[#9]

Thanks and this is working.

[#10]

Can I know what is Pie Popout and Text format ? when I opened plus sigh I can able to see these.