I'm using the Large function in conditional formatting to determine the top 3 scores in a range of numbers selected and coloring them based on their 1, 2, 3 rank. The conditional formatting works when the cells selected are in the same grouping [=LARGE(C$6:C$13,1)]; however, when I try to use the same formula but changing the cells to individually selected cells [=large(C$6,C$8,C$10,C$12,C$14,C$16,C$18,C$20,1)]...thoughts?