Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum (throw out highest and lowest) | Excel Worksheet Functions | |||
Highest & lowest place value / decimal places of cell value | Excel Worksheet Functions | |||
Highest High and Lowest Low | Excel Discussion (Misc queries) | |||
How to find highest, lowest and last cell in row? | Excel Discussion (Misc queries) | |||
How to find highest, lowest and last cell in a row? | Excel Worksheet Functions |