This content has been marked as final. Show 2 replies
I am colour coding an expression that returns a string value using a pick(match( statement)).
This is being done at the expression level by formatting the background.
however it seems to be missing out some random values.
For example it will colour code 'B' with the corresponding colour in one cell but will miss it out in another cell. I have checked and there are no spaces contained in the string comparisons.
Has any one come across this problem before or have any suggestions in what I can do?