Locating lowest/highest cell value in an array
 

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.

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.

Locating lowest/highest cell value in an array
 

Try conditional formatting with a formula.

Select the cells, say starting at A1, and in CF put a formula of
=A1=MAX(A1:A100)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Paul Rampenthal" wrote in message
...
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.

Locating lowest/highest cell value in an array
 

Thanks Frank, to further complicate matters I am trying to highlight the
highest/lowest cell value in a row. So each row would require a separate
formula. Is this possible?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Locating lowest/highest cell value in an array
 

Hi
try the following (for a row based formating)
- select your range (e.g. rows A1:X10)
- in the contional format dialog enter the following formula
=A1=MAX($A1:$X1)
- choose a format
..- repeat for the minimum:
=A1=MIN($A1:$X1)



--
Regards
Frank Kabel
Frankfurt, Germany


Paul Rampenthal wrote:
Thanks Frank, to further complicate matters I am trying to highlight
the highest/lowest cell value in a row. So each row would require a
separate formula. Is this possible?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!