you want F and I highlighted for the lowest score, but if there is a repeat, dont highlight the 2nd (or more) 1? so there will only be 1 cell highlighted?.
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =IF(COUNTIF($F$6:F6,MIN(F$6:F$11))>1,FALSE,F6=MIN(F$6:F$11))
Bookmarks