Highlight cells maximum and minimum in multiple columns

[jk51]

Hi,

How to highlight cells with two different fill colours one is yellow mean Maximum and purple mean minimum in mutliple columns in one go?

See example



FIELD 1 FIELD 2 FIELD 3 FIELD 4
23 49 3.4 5
232 666 0.43 33
6 496 0.042 22
67 9 1.3 99
5 6642 45.6 77

Many thanks

Mr Singh

 

[deciog]

jk51, Good Morning in Brazil.

Check if this way you want

Decio

 

[GraH - Guido]

Hi Decio,
Your formulae in CF could be simplified. eg. MIN(C$3:C$12)=C3 or MAX(C$3:C$12)=C3 is enough. The IF in both statements is redundant since CF only works if the formula used returns TRUE.

 

[deciog]

Thank you, GraH I learned one more.

Thank you very much

Decio

 

[GraH - Guido]

You're welcome, Decio. It's how we all learn from each other here.