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