Derivation of min and max values
You can probably achieve this with conditional formatting.
If you select the range and then go to conditional formatting and select
Fomula is
=RANK(E3,$A$1:$BL$96,1)<=10
Select the required format.
Enter a second condition where formula is
=RANK(E3,$A$1:$BL$96,0)<=10
and select format for largest ten.
Rowan
"bandy2000" wrote:
Hi
I have a data in a 96 by 64 field. Every cell in this field contains data.
How can I find the 10 biggest and smalles Values and then maybe select them
or change the
Background Colour or do any other change of the font?
Thanks
|