Conditional Formatting of cells containing text
 

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?

Conditional Formatting of cells containing text
 

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

2. From menu FormatConditional Formatting

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

Click Format ButtonPattern and select your color (say Red)

4. Click on Add button.

5. For Condition2Select 'Formula Is' and enter the below formula

=FIND("CORP-SOP",A1)

6. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Elin" wrote:

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?

Conditional Formatting of cells containing text
 

You need two conditions with each condition using FORMULA IS

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

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



"Elin" wrote:

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?

Conditional Formatting of cells containing text
 

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?

Conditional Formatting of cells containing text
 

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

"Joel" wrote:

You need two conditions with each condition using FORMULA IS

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

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



"Elin" wrote:

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?