Conditional Text Format in Expression

[london1980]

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

[luizmendes118]

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())

[MarcoWedel]

please post a sample qvw that you want to test this function with.

thanks

regards

Marco

[idogridish2 · Accepted solution]

hi london1980

you can use

if(WildMatch(Field,'*X:0A*','*D:01*'),LightRed(),LightGreen())

see the attached

cheers

[london1980]

thank you all, wildmatch did the trick