kopibean
asked on
How to display different colors for field values in column in view?
I have a number editable field which will contains 10 or 20 or 35 or 55 etc.
In my view under a column, i have the formula ->
Bgr := 255:255:255;
Chr := 255:0:0;
@If(projectCompP="10";Chr: Bgr;"")
but I do not see the color and the value display?
Please advise. Thank you.
In my view under a column, i have the formula ->
Bgr := 255:255:255;
Chr := 255:0:0;
@If(projectCompP="10";Chr:
but I do not see the color and the value display?
Please advise. Thank you.
Rank: Sage
Is this what you were looking for?Yes No
madheeswar:
the code will be in a column and for the values to display u need to have another column.
Example:
First column: In the column properties, enable Use value as color
red := 255:0:0;
apricot := 0:128:0;
@If(status="Open";red;apri
Second column:
Status
ASKER
Hi,
I have tried your solution. It works only for dkgreen:white?
Below is my formula:
red := 255:0:0;
dkgreen := 0:128:0;
dkblue := 0:0:128;
white := 255:255:255;
@If(projectCompP<="99%";dk green:whit e;projectC ompP="0%"; red:white; projectCom pP="100%"; dkblue:whi te;"")
Pls advise.
I have tried your solution. It works only for dkgreen:white?
Below is my formula:
red := 255:0:0;
dkgreen := 0:128:0;
dkblue := 0:0:128;
white := 255:255:255;
@If(projectCompP<="99%";dk
Pls advise.
Use this:
red := 255:0:0;
dkgreen := 0:128:0;
dkblue := 0:0:128;
white := 255:255:255;
apricot := 0:128:0;
@If(projectCompP<="99%";dk green:whit e;projectC ompP="0%"; red:white; projectCom pP="100%"; dkblue:whi te;apricot :white)
red := 255:0:0;
dkgreen := 0:128:0;
dkblue := 0:0:128;
white := 255:255:255;
apricot := 0:128:0;
@If(projectCompP<="99%";dk
ASKER
Hi,
I have tried your formula but it does not work.
If projectCompP=10% and the projectCompP=100%, they are the same colors.
Is it have something to do with this -> projectCompP<="99%"?
Pls advise.
I have tried your formula but it does not work.
If projectCompP=10% and the projectCompP=100%, they are the same colors.
Is it have something to do with this -> projectCompP<="99%"?
Pls advise.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much!
Example:
First column:
red := 255:0:0;
apricot := 0:128:0;
@If(status="Open";red;apri
Second column:
Status