Conditional Formatting of cells containing text

[Elin]

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?

 

[Jacob Skaria]

1. Suppose the data is in Column A. Select Column A.

2. From menu Format>Conditional Formatting>

3. For Condition1>Select 'Formula Is' and enter the below formula
=FIND("CORP-WI",A1)

Click Format Button>Pattern and select your color (say Red)

4. Click on Add button.

5. For Condition2>Select 'Formula Is' and enter the below formula

=FIND("CORP-SOP",A1)

6. Hit OK

If this post helps click Yes

 

[Joel]

You need two conditions with each condition using FORMULA IS

=LEFT(A8,9)="CORP-SOP-"

=LEFT(A8,8)="CORP-WI-"

 

[David Biddulph]

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

 

[Elin]

Thank you for putting me on track, it did not exactly work. I had to use this
formula to make it work correctly:

=LEFT(A1;9)="CORP-SOP-"

But that was just a small matter of trial and error

Thanks!
Elin