Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
If(SubStringCount(Concat(DISTINCT '|' & Name & '|'), '|VACANT|') = 1, RGB(255,0,0))
May be this
If(SubStringCount(Concat(DISTINCT '|' & Name & '|'), '|VACANT|') = 1, RGB(255,0,0))
Perfect. Thanks