I have a condition allreay that makes the odd numbers red, I would like to make the prime numbers green (all the lower primes except 2 are odd numbers). I think a If condition preceding the Mod would work to find them, but making the font green is another mater! This is the column(s) I enter the data into so in the cell formula box is the lotto number, ???????? 


=(MOD(B1:B163,2)<>0)*1