2 Replies Latest reply: Nov 24, 2017 8:25 AM by Phil Speight RSS

    Wildmatch Conditional formatting

    Phil Speight

      Hi

       

      I have created a concatenated field to show names.  See below :

       

      Concat(Name,Chr(10))

       

      How do I change the background colour if the Concatenated cell contains 'VACANT'

       

       

      Any help appreciated.

       

       

      Regards

       

       

       

      Phil