Hi!
In a report I've got some cells that should have different background-colors depending og their content. I have done this with conditional formatting, but now I would like to only use a part of the text as condition for the formatting.
Excample:
If the condition is "house", I would like both "house", "boathouse" and "houses" to be formatted.
Can anyone help me with this?
Please ask me for clarification.