Formatting Cell’s Text Color if defined Background Color is used
Hi all,
I have a table with some defined formatting of Background Color (in Chart Properties -> Expressions -> some Column Name -> Background Color -> Definition).
For example the cell becomes red if the value in that cell is negative and so on.
I can format the Text Color I the same way, but it is too cumbersome because of all the parameters.
What I want to do is to check if the cell’s Background Color is red and if it is, then to change the Text Color to white.
Something like that under Text Color -> Definition:
if(Background Color = rgb(255, 0, 0), rgb(255, 255, 255),)
