Hi there, I've got multiple lines of text that I would like conditional formatting added to, to highlight each sentence differently as it appears in a cell. i.e. Peter Rabbit (cell: a1 - highlight: red) Mother Goose (cell: a2 - highlight green) Simon Peter (cell: a3 - highlight: yellow) and so on... but the toolbar option only seems to allow for one colour and one parameter. Is there an equation for it? Thanks
Solved by I. J. in 13 mins