Thanks:  0
Likes:  0

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

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

2. 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.

3. 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 ]

4. > 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.

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

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

7. Is there a way to highlight the 10 highest numbers in a column.
=\$A2>=LARGE(\$A\$2:\$A\$100,10)

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•