formatting cells blank

[john_cash]

Hello to all,
i can't do this:

=$C$4>1 green
=$C$4="" blank

see Attachment

[AliGW]

You need only ONE rule for green:

=AND($C4>1,$C4<>"")

[john_cash]

Hi aligw work well.
And for new formatting for new attachment?

=$P$4="'" blank
=MAX($P4:$S4)=P4 red
=MIN($P4:$S4)=P4 green

[AliGW]

Same principle, but two rules:

=AND(P4<>"",MAX($P4:$S4)=P4)

=AND(P4<>"",MIN($P4:$S4)=P4)

You should work the next one out for yourself so that you know that you understand.

[john_cash]

Thanks ALIGW work well also the second formatting.
A greeting and thanks again
john

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.