Finding lowest number in a column

JRolph · Mar 6th, 2002, 04:15 PM

I need to find and highlight the single lowest number in a column. If more than one, do nothing. Can the highlighting be done by conditional formatting?

IML · Mar 6th, 2002, 04:31 PM

Quote:

On 2002-03-06 15:15, JRolph wrote:
I need to find and highlight the single lowest number in a column. If more than one, do nothing. Can the highlighting be done by conditional formatting?

You can use
=AND(A1=MIN(A:A),COUNTIF(A:A,A1)=1)
as your conditional formatting formula for cell a1 of column A.

_________________
Good Luck

"Give a man a fish, feed him for a meal,
Teach a man to fish, he will be drunk on a boat every Saturday"

[ This Message was edited by: IML on 2002-03-06 15:34 ]

JRolph · Mar 6th, 2002, 08:26 PM

Thank you very much! This works great.
One other question, I need to add this to some columns with formulas. Will this interfer with those formulas?

IML · Mar 7th, 2002, 12:23 PM

Quote:

On 2002-03-06 19:26, JRolph wrote:
Thank you very much! This works great.
One other question, I need to add this to some columns with formulas. Will this interfer with those formulas?

No, it will not. The conditional formatting formula will calculate based on the results of the formulas in your cells.

[ This Message was edited by: IML on 2002-03-07 11:24 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 04:15 PM	#1
JRolph New Member Join Date: Mar 2002 Posts: 14	I need to find and highlight the single lowest number in a column. If more than one, do nothing. Can the highlighting be done by conditional formatting?

Mar 6th, 2002, 08:26 PM	#3
JRolph New Member Join Date: Mar 2002 Posts: 14	Thank you very much! This works great. One other question, I need to add this to some columns with formulas. Will this interfer with those formulas?