Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
nvijay5757
Creator
Creator

Font color

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

Labels (3)
6 Replies
vinieme12
Champion III
Champion III

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?

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
nvijay5757
Creator
Creator
Author

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

nvijay5757_0-1669696017401.png

 

vinieme12
Champion III
Champion III

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()
)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
nvijay5757
Creator
Creator
Author

Hi,

i am getting same color for both values.

nvijay5757_0-1669704960616.png

 

vinieme12
Champion III
Champion III

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

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
nvijay5757
Creator
Creator
Author

Ok. in text object also same.