IF MAX (yellow), MIN (blue) conditional formatting

Hi All,

I have successfully used the following functions with conditional formatting:

=IF(C4>=MAX($C$4:$C$11),C4,IF(C4=MIN($C$4:$C$11),C4,""))

CONDITIONAL FORMATTING:
MIN (highlited in blue)

=$D4=MIN($D4:$D11)

MAX (highlited in yellow)

=$D4=MAX($D4:$D11)

conditional formatting for both working fine. However, if the MAX value is below MIN, both will be highlited in blue instead of yellow & blue.

What went wrong?

Please find attachment.
Thank-You very much

Hi Pepe Le Mokko,

Yes, it fixed. So, i cannot put both conditions to column D, but instead conditional formatting to C & =IF(C4>=MAX($C$4:$C$11),C4,IF(C4=MIN($C$4:$C$11),C4,"")) to column D
ok got it!

Will mark as SOLVED & added reputation to you.

Thank-You very much