I've tried using conditional formatting function but still cant figure it out. I made a school grade spreadsheet, I used the SMALL function to drop 1 of the lowest grades from a set of values and it worked fine. But now I'm trying to format only one of my scores by changing its color, etc. But there are some cells with the same duplicate values and it makes the changes to all the lowest cells. In other words, when I'm trying to identify just one of the lowest scores, it changes the color to all the same valued cells. How do I make these changes?