Conditional Formatting Row Golf/Skin

[VinceF]

Determining a "skin" for a golf hole.

With conditional formatting I can highlight the lowest number(s) for a given hole but I'm looking to highlight the number only if it's the lowest number without tying.

Example:
A1 thru A20 all contain numbers...the low number is 3 but there are two cells with 3's. I wouldn't want to highlight the 3's because it's a tie. However is there was only one 3 then I would want it highlighted.

Hope this makes sense....


Thanks for your help...

Vince

 

[JoeMo]

Use this CF rule:

=AND($A1=MIN($A$1:$A$20),COUNTIF($A$1:$A$20,$A1)=1)

 

[VinceF]

Thank you JoeMo...it worked perfectly...!

Vince

 

[JoeMo]

Thank you JoeMo...it worked perfectly...!

Vince

You are welcome - thanks for the reply.