I would like to use if and then statements to recognize P, O, or C
if the cell has P, O, or C I want the row to change colors Blue, Green, Red
Is this possible

Use Conditional Formatting with the three conditions.

Regards

Trevor


"Ed" wrote in message
...
I would like to use if and then statements to recognize P, O, or C
if the cell has P, O, or C I want the row to change colors Blue, Green,
Red
Is this possible

Select a row or range in a row.

Then assuming A1 is the cell with P, O or C

FormatConditional FormattingCondtion 1Formula is

=$A$1="P"

Format as Blue

Add

Condition 2.......=$A$1="O"

etc. for condition 3


Gord Dibben MS Excel MVP

On Tue, 8 Aug 2006 14:41:02 -0700, Ed wrote:

I would like to use if and then statements to recognize P, O, or C
if the cell has P, O, or C I want the row to change colors Blue, Green, Red
Is this possible

The CF works in the cell how do I get to work for the entire? So if I input
"p" the entire row of 10 turns blue?


"Trevor Shuttleworth" wrote:

Use Conditional Formatting with the three conditions.

Regards

Trevor


"Ed" wrote in message
...
I would like to use if and then statements to recognize P, O, or C
if the cell has P, O, or C I want the row to change colors Blue, Green,
Red
Is this possible

Ed

Have a look at my post also.


Gord Dibben MS Excel MVP

On Tue, 8 Aug 2006 15:01:02 -0700, Ed wrote:

The CF works in the cell how do I get to work for the entire? So if I input
"p" the entire row of 10 turns blue?


"Trevor Shuttleworth" wrote:

Use Conditional Formatting with the three conditions.

Regards

Trevor


"Ed" wrote in message
...
I would like to use if and then statements to recognize P, O, or C
if the cell has P, O, or C I want the row to change colors Blue, Green,
Red
Is this possible

Hey, almost there.

So specifically every cell in column a will change to P, O, or C
How do I format the entire worksheet to do this?
Or how do I copy this format.

"Gord Dibben" wrote:

Select a row or range in a row.

Then assuming A1 is the cell with P, O or C

FormatConditional FormattingCondtion 1Formula is

=$A$1="P"

Format as Blue

Add

Condition 2.......=$A$1="O"

etc. for condition 3


Gord Dibben MS Excel MVP

On Tue, 8 Aug 2006 14:41:02 -0700, Ed wrote:

I would like to use if and then statements to recognize P, O, or C
if the cell has P, O, or C I want the row to change colors Blue, Green, Red
Is this possible

Every cell in Row 1 not Column A, will change if A1 is P,O or C
You have to have lock on to $A$1 in the Conditional Format Formula to get
row to change on A1 contents

You'll have to change this to $A1, then copy the format from Row 1 to
any/all rows that you want the same formatting

Steve

On Tue, 08 Aug 2006 23:19:03 +0100, Ed
wrote:

Hey, almost there.

So specifically every cell in column a will change to P, O, or C
How do I format the entire worksheet to do this?
Or how do I copy this format.

"Gord Dibben" wrote:

Select a row or range in a row.

Then assuming A1 is the cell with P, O or C

FormatConditional FormattingCondtion 1Formula is

=$A$1="P"

Format as Blue

Add

Condition 2.......=$A$1="O"

etc. for condition 3


Gord Dibben MS Excel MVP

On Tue, 8 Aug 2006 14:41:02 -0700, Ed
wrote:

I would like to use if and then statements to recognize P, O, or C
if the cell has P, O, or C I want the row to change colors Blue,
Green, Red
Is this possible





--
Steve (3)

Are you saying that Column A cells will have a P, O or C?

If so, select a range of rows and CFFormula is

=$A1=P...........I misled you in first post by locking just A1

Note the single $ sign to lock just the Column A but not the row.

I wouldn't format the whole worksheet this way.

Just format a couple hundred rows for now and use the Format Painter to copy to
more rows later.


Gord


On Tue, 8 Aug 2006 15:19:03 -0700, Ed wrote:

Hey, almost there.

So specifically every cell in column a will change to P, O, or C
How do I format the entire worksheet to do this?
Or how do I copy this format.

"Gord Dibben" wrote:

Select a row or range in a row.

Then assuming A1 is the cell with P, O or C

FormatConditional FormattingCondtion 1Formula is

=$A$1="P"

Format as Blue

Add

Condition 2.......=$A$1="O"

etc. for condition 3


Gord Dibben MS Excel MVP

On Tue, 8 Aug 2006 14:41:02 -0700, Ed wrote:

I would like to use if and then statements to recognize P, O, or C
if the cell has P, O, or C I want the row to change colors Blue, Green, Red
Is this possible