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