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