Highlighting the highest/lowest cell value in a row or colum

[all4sport]

Is there any way to have excel automatically highlight the highest or lowest number in a column. I don't wish for it to sort or move anything around. I just have weekly data and I want to automatically see the highs and lows.

 

[Brian from Maui]

Just curious, why =a1=min? what does a1 do?

 

[Aladin Akyurek]

On 2002-03-02 12:22, Brian from Maui wrote:
Just curious, why =a1=min? what does a1 do?

Brian,

When you try to set up the same cond format for eeach cell in the range interest, you need to use relative addressing: e.g., A1 and not $A$1.

When

=A1=MIN($A$1:$A$4)

in cond format is applied applied to $A$1:$A$4, the formula becomes:

=A1=MIN($A$1:$A$4) in A1,

=A2=MIN($A$1:$A$4) in A2,

=A3=MIN($A$1:$A$4) in A2,and

=A4=MIN($A$1:$A$4) in A4.

By the way, it checks whether a given cell value is equal to the MIN value of A:A4.

Aladin

 

[Brian from Maui]

Mahalo,

I understand now!

So if I want to compare values to A1 or want a value lower than in A1, would I use =$a$1=min?


This message was edited by Brian from Maui on 2002-03-02 12:45

 

[Aladin Akyurek]

> So if I want to compare values to A1 or want a value lower than in A1, would I use =$a$1=min?

Populate B1:B4 with numbers and also enter a number in A1.

Select now B1:B4, use

=B1<$A$1

as the formula in cond format & select formatting you want.

Now any cell in B1:B4 with a value lower than the value in A1 will show the formatting you applied.

Aladin

 

[all4sport]

It finally works...thanks everyone for all your help!!!

 

[alien4d]

Is there a way to highlight the 10 highest numbers in a column.

 

[Aladin Akyurek]

Is there a way to highlight the 10 highest numbers in a column.

=$A2>=LARGE($A$2:$A$100,10)