Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table and a field that has a field similar to the one shown below
Data
Yes - ABCD
Yes - XYZ
Yes - QWER
No - ABCD
No - XYZ
I need to get an expression where if the filed values has 'Yes' in it regardless of what's attached to it, the color of the field should be Green, or it must be Red otherwise. Any help how to frame the expression? The expression should only see if the field value has Yes or No regardless of the following data.
May be this in background color expression:
If(WildMatch(Data, 'Yes*'), Green(), Red())
Something like
IF(Data LIKE 'Yes*', Lightgreen(), Lightred() )
Let me try both the expressions and come back with the results. Thanks a lot guys.
Thank you so much both of you. It worked.
If(Data='Yes',Green(),Red())
Or you can even try the below expression for better performance.
=if(complex expression, dual(‘Y’,green()), dual(‘N’,red()))
Great, if you got what you were looking for, please close the thread