Format/Conditional Formatting/ Formula Is (not cell value is)/
=LEFT(A2,8)="CORP-SOP" choose your first colour
Add/ Formula Is / =LEFT(A2,7)="CORP-WI" choose your second colour
--
David Biddulph

"Elin" wrote in message
...
Hi!
In Excel 2003, I have a column looking like this:

CORP-SOP-0012
CORP-WI-0123
CORP-SOP-0034
CORP-WI-0165

How can I make all the cells beginning with "CORP-SOP" one colour and all
the cells beginning with "CORP-WI" another?