EXCEL Conditional Formatting

[FDG]

I have a spreadsheet for a group of golfers that play weekly. Different number of players each week, so I need to not process a conditional format formula on a line that is blank in col BI.
I have been trying to use IF Blank before the code, but cannot seem to get the syntax correct. Any help would be appreciated.

=AND(D7=MIN(D$7:D$38),COUNTIF(D$7:D$38,MIN(D$7:D$38))=1)

Test cell is for data in D7 in BI7 where I place an X for a valid player. Non Valid player would be blank.
There is more code to highlight the cell in color if it is the only cell with the lowest score.
Thanks

[Richard Buttrey]

Hi,

In the same CF perhaps

=AND(BI7<>"",AND(D7=MIN(D$7:D$38),COUNTIF(D$7:D$38,MIN(D$7:D$38))=1))

otherwise a second (earlier in precedence terms) CF which uses the default format

=BI7&=""

and set the format as appropriate

[FDG]

Richard, your formula Did not work. My question was flawed. Turns out I really need to set the condition on the "applies to" section of excel 2010's Highlight if code.

[FDG]

Okay, Trying again to explain the need and how to modify the current foumula. I have a conditional formula and range to highlight with color a cell in each of 18 columns if and only if that number is the lowest number and not duplicated. Currently I have to sort names from another sheet and copy to the start of a row in this sheet and also copy a handicap number into a later col in the same row. I would like to copy all the names and handicaps to this sheet and select only an active list of rows to be evaluated for lowest number in the col. So I have added a col outside the evaluation range which I mark with an X to indicate the row "should be" included. Problem for me is I need help with the formulas to make only the selected rows work. Here are the formulas that work with only contiguous rows. I need to bypass any row that has a blank in row $BI7:$BI38.

=AND(D7=MIN(D$7:D$38),COUNTIF(D$7:D$38,MIN(D$7:D$38))=1)
Applies to
=$AF$7:$AF$38,$BD$7:$BD$38,$BA$7:$BA$38,$AX$7:$AX$38,$AU$7:$AU$38,$AR$7:$AR$38,$AO$7:$AO$38,$AL$7:$AL$38,$AI$7:$AI$38,$AB$7:$AB$38,$Y$7:$Y$38,$V$7:$V$38,$S$7:$S$38,$P$7:$P$38,$M$7:$M$38,$J$7:$J$38,$G$7:$G$38,$D$7:$D$38

If it would help tell me how to post a sheet that is currently filled out.
Thanks
Dale