Change the font color of a cell in relation with it's background color

[#1]

Hi everyone, I am new to Qlikview and I need some help. I have a table with certain data and depending on whether the data meets or does not meet certain criteria the background of each cell is colored in green, yellow or red. The font color (text color) is always black. I would like to change it to white for the cells where the background color is red in order to make it more readable. I tried with "Custom format Cell" but it changed the entire column or the entire table. Please advise how should I change the font color and make it dependent on the background color of a cell.

Thank you in advance !

[oknotsen]

You can add an expression to decide the color of the text. This is done on the expression tab. See attachment for the location.

[robert_mika · Accepted solution]

Try to use the same condition for Text as you used for the red background.

Feeling Qlikngry?

How To /Missing Manual(25 articles)

[#4]

Thanks ! I thought of that, it's a bit of a complex condition, but as I needed only to change the color code it worked out fine! Thanks again