I have a list of competitions and would like to highlight finals. So would like to highlight any cell that contains final for example club final, pairs final.
In the attached example I would like any cell in column B that has the word final not including semi-final to be highlight in a colourtest.xlsx