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