Findiing highest and lowest in rows and columns

[NetNathan1]

I have several rows and columns of numerical data.
What is the easiest way to find he highest and lowest number in th
cells?

Can I highlight the highest cell in red and lowest cell in blue

Can this be done on a .csv file also

 

[lhkittle]

I have several rows and columns of numerical data.

What is the easiest way to find he highest and lowest number in the

cells?



Can I highlight the highest cell in red and lowest cell in blue?



Can this be done on a .csv file also?

For columns try:

=LARGE(A1:A10,1)
=SMALL(A1:A10,1)

For rows try:
=LARGE(A1:Z1,1)
=SMALL(A1:Z1,1)

HTH
Regards,
Howard

 

[lhkittle]

I have several rows and columns of numerical data.

What is the easiest way to find he highest and lowest number in the

cells?



Can I highlight the highest cell in red and lowest cell in blue?



Can this be done on a .csv file also?

Overlooked the color aspect. Take a look at conditional formatting.

I don't know about .csv file.

H'wd

 

[NetNathan1]

Overlooked the color aspect. Take a look at conditional formatting

I don't know about .csv file

H'w

I assume rows and columns would b

=LARGE(A110,1
=SMALL(A110,1
Tested works good....Thank

Now just t figure out conditional formatting....the more complicate
part

It will work with a csv file I will just have to save it to an .xls t
retain colors and formulas