Font color

[nvijay5757]

Hi,

i am trying font color.

my expression is :

=If(( (Count({<KD_new={'KD'},Modes11={'8RB'}>} DISTINCT Modes11))>=1),'KD'&
Pick(Match(Count({<KD_new={'KD'},Modes11={'8RB'}>} DISTINCT Modes11),'1','2','3','4','5','6'),chr(185),chr(178),chr(179),chr(8308),chr(8309),chr(8310)),
If(( (Count({<KD_new={'nKD'},Modes11={'8RB'}>} DISTINCT Modes11))>=1),'nKD'))&''&

If(( (Count({<KD_new={'KD'},Modes11={'8UNC'}>} DISTINCT Modes11))>=1),', KD'&
Pick(Match(Count({<KD_new={'KD'},Modes11={'8UNC'}>} DISTINCT Modes11),'1','2','3','4','5','6'),chr(185),chr(178),chr(179),chr(8308),chr(8309),chr(8310)),
If(( (Count({<KD_new={'nKD'},Modes11={'8UNC'}>} DISTINCT Modes11))>=1),', nKD'))

output is KD, nKD.  here font color is if KD blue color, if nKD black color.

i have tried.

IF(Count({<KD_new={'KD'},Modes11={'8UNC'}>} DISTINCT Test)>=1 and Count({<KD_new={'nKD'},Modes11={'8UNC'}>} DISTINCT Test)=0,RGB(0,0,240),Black())  for one is working how will give both KD, nKD.

Thanks

[vinieme12]

IF(Count({<KD_new={'KD'},Modes11={'8UNC'}>} DISTINCT Test)>=1 and Count({<KD_new={'nKD'},Modes11={'8UNC'}>} DISTINCT Test)=0,RGB(0,0,240),Black())  for one is working how will give both 8RB,8UNC.

can you elaborate maybe with screenshots what are you trying to do here?

[nvijay5757]

Hi Vineeth,

above expression updated.

in text object or in table we are showing KD, nKD.  

if condition is true then KD. else nKD.

like if condition is true then blue color else black color.

ex: below screen shot KD-blue color, nKD - black color

[vinieme12]

try below

=If( (Count({<KD_new={'KD'},Modes11={'8RB'}>} DISTINCT Modes11)>=1) or (Count({<KD_new={'KD'},Modes11={'8UNC'}>} DISTINCT Modes11)>=1) ,RGB(0,0,240)

,if( (Count({<KD_new={'nKD'},Modes11={'8RB'}>} DISTINCT Modes11)>=1) or (Count({<KD_new={'nKD'},Modes11={'8UNC'}>} DISTINCT Modes11)>=1) ,black()
)

[nvijay5757]

Hi,

i am getting same color for both values.

[vinieme12]

if you are referring to the column 8RB   ;  i can confirm one cell can only have one font color

[nvijay5757]

Ok. in text object also same.