topic Re: Wilmatch Conditional formatting in QlikView https://community.qlik.com/t5/QlikView/Wildmatch-Conditional-formatting/m-p/1452358#M611590 <HTML><HEAD></HEAD><BODY><P>Perfect.&nbsp; Thanks</P></BODY></HTML> Fri, 24 Nov 2017 13:25:53 GMT Anonymous 2017-11-24T13:25:53Z Wildmatch Conditional formatting https://community.qlik.com/t5/QlikView/Wildmatch-Conditional-formatting/m-p/1452356#M611588 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have created a concatenated field to show names.&nbsp; See below :</P><P></P><P>Concat(Name,Chr(10))</P><P></P><P>How do I change the background colour if the Concatenated cell contains 'VACANT'</P><P></P><P></P><P>Any help appreciated.</P><P></P><P></P><P>Regards</P><P></P><P></P><P></P><P>Phil</P></BODY></HTML> Fri, 24 Nov 2017 13:09:12 GMT https://community.qlik.com/t5/QlikView/Wildmatch-Conditional-formatting/m-p/1452356#M611588 Anonymous 2017-11-24T13:09:12Z Re: Wilmatch Conditional formatting https://community.qlik.com/t5/QlikView/Wildmatch-Conditional-formatting/m-p/1452357#M611589 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>If(SubStringCount(Concat(DISTINCT '|' &amp; Name &amp; '|'), '|VACANT|') = 1, RGB(255,0,0))</STRONG></P></BODY></HTML> Fri, 24 Nov 2017 13:13:17 GMT https://community.qlik.com/t5/QlikView/Wildmatch-Conditional-formatting/m-p/1452357#M611589 sunny_talwar 2017-11-24T13:13:17Z Re: Wilmatch Conditional formatting https://community.qlik.com/t5/QlikView/Wildmatch-Conditional-formatting/m-p/1452358#M611590 <HTML><HEAD></HEAD><BODY><P>Perfect.&nbsp; Thanks</P></BODY></HTML> Fri, 24 Nov 2017 13:25:53 GMT https://community.qlik.com/t5/QlikView/Wildmatch-Conditional-formatting/m-p/1452358#M611590 Anonymous 2017-11-24T13:25:53Z