Conditionl format for 1 cellthat looks at 3 cells.
 

Thank you experts for all your help:

Question:

Conditionl format formula for "N7"

1. If C7,D7,E7 are 28 turn red

2. If C7,D7,E7 are <28 turn green

I can do the color part(easy I know)

Queston:

Is there a way around the 3 conditional format limit for a cell?

Thank you in advance.

Mark

Conditionl format for 1 cellthat looks at 3 cells.
 

Your question is ambiguous. If you mean that all of C7,D7,E7 should be 28 to
turn the cell red then

=AND(C728,D728,E728)

the same for green with < instead of . If this is not the case, specify it!


Regards,
Stefi

€žMark€� ezt Ã*rta:

Thank you experts for all your help:

Question:

Conditionl format formula for "N7"

1. If C7,D7,E7 are 28 turn red

2. If C7,D7,E7 are <28 turn green

I can do the color part(easy I know)

Queston:

Is there a way around the 3 conditional format limit for a cell?

Thank you in advance.

Mark

Conditionl format for 1 cellthat looks at 3 cells.
 

With N7 selected, click on Format | Conditional Formatting and choose
Formula Is rather than Cell Vlaue Is in the first box. Enter this
formula:

=AND(C728,D728,E728)

Then click the Format button, choose the Patterns tab and choose red.
Click OK, then Add to set up your second condition. Formula Is again,
with this formula:

=AND(C7<28,D7<28,E7<28)

Set this for green, then OK twice to exit the dialogue boxes. The
formulae will set the colours if all 3 conditions are met.

XL2007 has more conditional formats per cell (I think it's about 60),
and Bob Phillips has a free add-in he

http://www.xldynamic.com/source/xld.....Download.html

which will give you up to 30.

Hope this helps.

Pete

On Feb 5, 2:19*pm, Mark wrote:
Thank you experts for all your help:

Question:

Conditionl format formula for "N7"

1. If C7,D7,E7 are 28 turn red

2. If C7,D7,E7 are <28 turn green

I can do the color part(easy I know)

Queston:

Is there a way around the 3 conditional format limit for a cell?

Thank you in advance.

Mark

Conditionl format for 1 cellthat looks at 3 cells.
 

Hi Mark
If you're using XL2003 and older, the answer is NO except a macro will do
it.
HTH
John
"Mark" wrote in message
...
Thank you experts for all your help:

Question:

Conditionl format formula for "N7"

1. If C7,D7,E7 are 28 turn red

2. If C7,D7,E7 are <28 turn green

I can do the color part(easy I know)

Queston:

Is there a way around the 3 conditional format limit for a cell?

Thank you in advance.

Mark

Conditionl format for 1 cellthat looks at 3 cells.
 

Try this:

1) Conditional Format for Cell (N7)

Conditional1: Red
=IF(OR($C$728,$D$728,$E$728),TRUE,FALSE)

Condition2: Green
=IF(OR($C$7<28,$D$7<28,$E$7<28),TRUE,FALSE)


2) Enter a formula to Cell (N7)
=MAX(C7:E7)


3) Now you try enter any number in cells C7,D7,E7.

Regards.


"Mark" wrote in message
...
Thank you experts for all your help:

Question:

Conditionl format formula for "N7"

1. If C7,D7,E7 are 28 turn red

2. If C7,D7,E7 are <28 turn green

I can do the color part(easy I know)

Queston:

Is there a way around the 3 conditional format limit for a cell?

Thank you in advance.

Mark

Conditionl format for 1 cellthat looks at 3 cells.
 

Yes, it's exact now! The formulae are

=SUM(C7:E7)28
and
=SUM(C7:E7)<28

Regards,
Stefi

€žMark€� ezt Ã*rta:

O I see now what you meant

NO!

C7+D7+E7 sum 28

is more clear?

Mark

"Mark" wrote:

Thank you experts for all your help:

Question:

Conditionl format formula for "N7"

1. If C7,D7,E7 are 28 turn red

2. If C7,D7,E7 are <28 turn green

I can do the color part(easy I know)

Queston:

Is there a way around the 3 conditional format limit for a cell?

Thank you in advance.

Mark

Conditionl format for 1 cellthat looks at 3 cells.
 

Stefi,

I'm not smart enough to be ambiguous!

Barring that.

Yes!

C7 + D7+ E7 if than 28 cell N7 colors.

each cell has a number.

Is what you wrote still the same formula. Thank you for helping.

Mark.

"Mark" wrote:

Thank you experts for all your help:

Question:

Conditionl format formula for "N7"

1. If C7,D7,E7 are 28 turn red

2. If C7,D7,E7 are <28 turn green

I can do the color part(easy I know)

Queston:

Is there a way around the 3 conditional format limit for a cell?

Thank you in advance.

Mark

Conditionl format for 1 cellthat looks at 3 cells.
 

O I see now what you meant

NO!

C7+D7+E7 sum 28

is more clear?

Mark

"Mark" wrote:

Thank you experts for all your help:

Question:

Conditionl format formula for "N7"

1. If C7,D7,E7 are 28 turn red

2. If C7,D7,E7 are <28 turn green

I can do the color part(easy I know)

Queston:

Is there a way around the 3 conditional format limit for a cell?

Thank you in advance.

Mark

Conditionl format for 1 cellthat looks at 3 cells.
 

Thank you Pete. osh, the help hee is fanatstic.

"Pete_UK" wrote:

With N7 selected, click on Format | Conditional Formatting and choose
Formula Is rather than Cell Vlaue Is in the first box. Enter this
formula:

=AND(C728,D728,E728)

Then click the Format button, choose the Patterns tab and choose red.
Click OK, then Add to set up your second condition. Formula Is again,
with this formula:

=AND(C7<28,D7<28,E7<28)

Set this for green, then OK twice to exit the dialogue boxes. The
formulae will set the colours if all 3 conditions are met.

XL2007 has more conditional formats per cell (I think it's about 60),
and Bob Phillips has a free add-in he

http://www.xldynamic.com/source/xld.....Download.html

which will give you up to 30.

Hope this helps.

Pete

On Feb 5, 2:19 pm, Mark wrote:
Thank you experts for all your help:

Question:

Conditionl format formula for "N7"

1. If C7,D7,E7 are 28 turn red

2. If C7,D7,E7 are <28 turn green

I can do the color part(easy I know)

Queston:

Is there a way around the 3 conditional format limit for a cell?

Thank you in advance.

Mark

Conditionl format for 1 cellthat looks at 3 cells.
 

Perfect. Thank you very much

"Stefi" wrote:

Yes, it's exact now! The formulae are

=SUM(C7:E7)28
and
=SUM(C7:E7)<28

Regards,
Stefi

€žMark€� ezt Ã*rta:

O I see now what you meant

NO!

C7+D7+E7 sum 28

is more clear?

Mark

"Mark" wrote:

Thank you experts for all your help:

Question:

Conditionl format formula for "N7"

1. If C7,D7,E7 are 28 turn red

2. If C7,D7,E7 are <28 turn green

I can do the color part(easy I know)

Queston:

Is there a way around the 3 conditional format limit for a cell?

Thank you in advance.

Mark