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