How do i format all cells containing a certain text string to have a different color etc.?

Not an experienced user, just need to know this.

Search Conditional Formatting in the help - F1 Or see Conditional Formatting - LibreOffice Help and also the link at the bottom of that page.