How to change wording color to white when black ground is Red ?

[paulyeo11]

Hi All

I have a Table with one color show the variance. i like the word color to be white when black ground color is red. Any idea how to do it ?

Paul

[paulyeo11]

My QV Doc

[Anonymous]

How about using something like this for your expression's text colour expression ?

if(PLUS = 'P' and Column(3) >0 , Black(), If(PLUS = 'N' and Column(3) < 0 , lIGHTGreen(), white()))

[MK_QSL · Accepted solution]

Change Text Color Expression as below

if(PLUS = 'P' and Column(3) >0 , Black(),

If(PLUS = 'N' and Column(3) < 0 , Black(), White()))

[paulyeo11]

Thank Manish