More help with conditional formatting

JRolph

New Member
Joined
Mar 5, 2002
Messages
14
The formula +AND(A1=MIN(A:A),COUNTIF(A:A,A1)=1) works very well to find the single lowest number in a column on a worksheet without column headers. My problem is that my worksheet needs column numbers (skin game sheet for golf) 1-18 and handicap numbers for each hole. How can I get this formula to ignore row 1 & row 2?
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Hi
What is in A1? This formula only returns True or False for me, not a number.
regards
Derek
 
Upvote 0
The conditional formatting looks for the single lowest number in the column. If there is one lowest, the format changes to dark grey with white font. If more than one, does nothing.
 
Upvote 0
Hi
Sorry, I didn't realise your formula was in your conditional formatting.

Select Column A and delete all conditional formatting.
Select A3 and conditionally format it with the following formula (this covers the range A3:A200 - increase the 200 if you use more rows)

=AND(A3=MIN($A$3:$A$200),COUNTIF($A$3:$A$200,A3)=1)

Select A3:A200, select conditional formatting and click OK

That should fix it for you
regards
Derek
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,027
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

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.
Go back
Back
Top