I want to color the text of my table rows. For this I use the following "if-clause" (**bleep**ty if-clause, I know, sorry for that ;-)):
=if([A]='Agreed' and [B]='Commented by me' and [C]=1,rgb(130,66,159),
if([A]='Open' and not [A]='Agreed' and ([B]='Commented by me' or
[B]='Agreed') and [C]=1,rgb(21,147,63),
if([A]='Closed' and [C]=1,rgb(182,215,234),
if(([A]='Open' or [A]='Agreed') and
([B]='Answered by me' or [B]='For Approval') and
[C]=1,yellow()))))
The problem is, that somehow the last if-clause is being ignored completely for coloring. The data behind it is processed correctly into my table, so I think there is basically no mistake within the whole if-clause.
Does anyone have a suggestion how to do or fix this?