Locating lowest/highest cell value in an array
Hi
if your data is in A1:A100 try the following:
- select this range
- goto 'Format - Conditional format'
- enter the following formula (for the maximum value):
=A1=MAX($A$1:$A$100)
- choose a format
- repeat for the minimum value
--
Regards
Frank Kabel
Frankfurt, Germany
Paul Rampenthal wrote:
I have been unsuccessfully trying to program an Excel
spreadsheet to locate the lowest or highest cell value in
an array by highlighting cell with shading or bolding of
cell data or some other method.
|