Using formula in CF to highlight muliple text items

Hi folks!

I would like excel to use conditional formatting to highlight a cell wherever it sees the first seven characters of a range of text. The normal CF method to highlight text doesn't seem to allow me to select a range of text, only a single text item may be checked in the list.

I believe the example I have attached explains this a bit better!

Thank you folks!

Select the entire range (A1:A42)

Conditional Formatting
New Rule
Use a formula to determine...

=OR(LEFT(A1,7)="SUB0041",LEFT(A1,7)="SUB0042",LEFT(A1,7)="SUB0010")

Format as required