pain cell max and min

  • Thread starter Thread starter yuvalbra
  • Start date Start date
Y

yuvalbra

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
Format>Conditional 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to determine min/max values of column 3
MAX and Min value 2
ScrollBar - set MIN/MAX cell value 2
How to calculate Min,Median,Max values in non consecutive rows via 4
Conditional Formating: MAX & MIN 3
Formulas using two cells 8
Dynamic MAX formula 2
Programming Min and Max 2

Back
Top