I have a list of numbers in A1:A12 as follows:
8I'm trying to conditionally format the two lowest numbers, in this case the "6" and one of the three "8's". When I used the Bottom rule in Conditional Formatting, it highlights the 6 and all three 8's, since those are the two lowest values in the list. In other words, after the conditional formatting, I always want 10 of the 12 numbers to remain unformatted.
8
8
12
12
12
12
12
12
12
12
6
Thanks in advance for your help.
Bookmarks