conditional formatting

[ribs58]

Trying to highlight lowest cell in columns...if 2 cells in same column
contain same low number I dont want any highlighted.Not sure
how to set up formatting statement in conditional formatting.

Any help out there? File example is attache

Attachment filename: skins.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=51726

 

[Frank Kabel]

Hi
if your values are in A1:A10 try the following:
- select cells A1:A10
- goto the conditional format dialog and enter the following formula
=(A1=MIN($A$1:$A$10))*(COUNTIF($A$1:$A$10)=1)

 

[ribs58]

Thanks for the help Frank,

My values are in D570
I highlighted these cells and entred the following formula

=(D5=MIN($D$5:$D$70))*(COUNTIF($D$:$D$70)=1)

but I get the error saying I entered too few arguements
Did I miss something?

Regards Jim A

 

[Frank Kabel]

Hi
sorry my fault. try
=(D5=MIN($D$5:$D$70))*(COUNTIF($D$:$D$70,D5)=1)

 

[ribs58]

oops I did enter
=(D5=MIN($D$5:$D$70))*(COUNTIF($D$5:$D$70)=1)

sometimes cells aren't always full up to D70 but they start at D5
would that make a difference

 

[ribs58]

Thanks Frank,

That did it, your a lifesaver!

Regards Jim A