Condtional Formatting: highlight MIN(s) but ignore blank cells

[needsomehelpher]

Hi there. I hate coming here because I'm always only asking questions, never answering them. Nevertheless, it's become habit now because I've always received help here and always received the solution.

I'm on Mac Office 08 and having trouble with a column of data that I want to apply a conditional format to:

G5:G49 contains missed sales in single or double digit numerals, and would like to highlight the minimums but ignore the bulk of blank cells at the bottom (which are basically days that haven't passed yet/unpopulated data). I've tried both "cell equals" and "Formula" but regardless of what I try, I'll either get nothing highlighted or only the blank cells.

I have one day with 0 missed sales, and have thus far been unable to get it highlighted.

Thank you for any help you can offer.

[sweep]

Hi,

How about this formula,

=AND(NOT(ISBLANK(G5)),G5=MIN($G$5:$G$49))

[asha3010]

Does this work for you?
Asha

I have used
IF(A1=LARGE($A$1:$A$5,COUNTIF($A$1:$A$5,">0")),TRUE,FALSE)

[zbor]

@asha:

As I understood 0 must be minimum if it's entered but not blank.
See sweep solution.

Also, CF works on TRUE/FALSE principle.

So your code can be shortened to:

=B1=LARGE($A$1:$A$5,COUNTIF($A$1:$A$5,">0"))

No need for IF and TRUE/FALSE returning in this case.

I hope this tip will help you in the challenges that comming

[asha3010]

Thanks very much Zbor for the tip. I learn something everyday!
Asha

[zbor]

Don't we all