thanks abmati but the formula needs to be dynamic, so as the numbers increase i would like the formula to continue to capture which is the highest, second highest and third highest in count. I believe your formul would only work for if it equals the static number (5,3,2).

Conditional formatting can currently capture the highest numbers but it would seem logical that they would also build in something to allow for the highest number of occurances as well.

Matty, The draw would result in both numbers being the same color, but again, the formula would essentially rear like, highest count in column A is formatted as red, the second highest count in column A is formatted as orange, and the 3rd highest count in column A is formatted as orange.

The preset conditional formatting allows for standard deviations from the average which gets kind of close to what im looking for but i cant get the second hightest and third highest to work consistantly.