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?
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
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
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.