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.

[#2]

Can I use at a time from A to Z  instead of A*, B* and so on?

[jerem1234]

Yea try:

=pick(mod(ord(left(Student,1)),64), black(), green(), magenta())

if all capital letters.

=pick(mod(ord(left(Student,1)),96), black(), green(), magenta())

if all lowercase letters.

If there is a mix, I think you'd have to go about listing them all unfortunately.

If you don't like the mod function, you can use:

pick(ord(left(Student,1))-64, black(), green(), magenta())

[#4]

Thanks and what is Mix means here?

[jerem1234]

I just mean if you have names like Anna, carl, David, Earl, jen, ... and so on. It won't work because the ascii numbers for lowercase and uppercase are different.

Hope this helps!

[#6]

Ok Thanks .

[magavi_framsteg]

Amelia,

It would really help you alot if you read the fmanual before asking questions like this.

Maybe you do understand that you take up valuable time for many people here.

You know, there exists online training classes that are free to attend-on-demand.

Asking a general question like "How do I get the RGB code" or "What is RGB?" does not belong here.

Google can help you with that.

Feel free to ask us specific questions to problems that you do not find in the manual or elsewhere on the forum (= forum ethics).

We are glad to help you.

But please: Try first. Then google or search the forum. Ask your colleagues. And if you've done your best and are stuck - then we're here to help you.

Please.

Try and keep the thread on topic. Imagine someone using your thread for help, and they have to read on about 100 questions that are irrelevant to them.

Trial and error is the best way of becoming a QV expert.

Help to self help is key. Not letting us write your code, instead point you the the right direction to help yourself.

Cheers! 😃