Format/ Conditional Formatting/ Formula Is:
=COUNTIF(A$1:A1,A1)=2
select your yellow colour.

Add, and similarly for the red for 3.
--
David Biddulph

"Amy" wrote in message
...
Please help! I have a spread sheet that is massive. I have one column with
a
million numbers in it. I need to color code it each time it shows up. The
first instance should be white, the second should be yellow, and the third
time it shows up it should be red. Is this possible? I have researched all
morning long. Please help! Thank you so much!