need macro that search the max value and the min value and change the
color of the cell (green for max , red for min)

regards
yuval

Hi,
you need conditional formatting....Select your range, goto
FormatConditional Formatting...in the file menu then (assuming your
range is A1:A10) enter this

Formula Is = =A1=MAX($A$1:$A$10) and set the format you want.

Repeat with MIN for minimum value...
Hth,
OJ

Assume that your range is A1:A10.
Select the range, go to FORMAT CONDITIONAL FORMATTING
in condition 1 box, you will have 'cell value is', in the next box select
'equal to', and enter the following in the 3rd box: max($A$1:$A$10). Click
on format and select green in the pattern tab (third tab).
Then Click 'ADD' to enter the second condition. This time enter min($A$1:$A
$10) and select red color.

Click ok. Note that the above formula should not be inside double quotes in
the boxes mentioned as above.

Mangesh

--
Message posted via http://www.officekb.com