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.

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

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