Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I was wondering if it's possible to add conditional text formatting in and Expression.
Basically I want to make the text colour red if the cell contains one of these two "X:0A" or "D:01".
Thanks
M
hi london1980
you can use
if(WildMatch(Field,'*X:0A*','*D:01*'),LightRed(),LightGreen())
see the attached
cheers
You can click on that plus and use at the text color an if to insert the conditions, like if(Field='X:0A' or Field='D:01',red(),black())
please post a sample qvw that you want to test this function with.
thanks
regards
Marco
hi london1980
you can use
if(WildMatch(Field,'*X:0A*','*D:01*'),LightRed(),LightGreen())
see the attached
cheers
thank you all, wildmatch did the trick