
Anonymous
Not applicable
2017-11-24
08:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Wildmatch Conditional formatting
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
888 Views
1 Solution
Accepted Solutions

MVP
2017-11-24
08:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
If(SubStringCount(Concat(DISTINCT '|' & Name & '|'), '|VACANT|') = 1, RGB(255,0,0))
814 Views
2 Replies

MVP
2017-11-24
08:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
If(SubStringCount(Concat(DISTINCT '|' & Name & '|'), '|VACANT|') = 1, RGB(255,0,0))
815 Views

Anonymous
Not applicable
2017-11-24
08:25 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Perfect. Thanks
814 Views
