Lottery numbers

I want to enter each lottery number into a seperate cell, then on a different row enter the winning numbers. Then have all the numbers we bought that were already entered earlier would change color to red if they match the winning numbers. Please help.

Format -> Conditional Formatting

Select all the cells you want to test.

Know the location of the winning numbers. I'll assume the winning numbers are in A25:F25.

Note the highlighted cell address (should be in the top left on your screen). I'll assume it's A2. (If you don't use the active cell address, it will mess up the colouring signficantly)

Use the formula:

=IF(ISERROR(MATCH(A2,$A$25:$F$25,0)),FALSE,TRUE)

And adjust your color to red.

Scott

Where do I put the formula?

Yes, it is, but I need to hav the six number show up if it matchs as the mega number

Originally Posted by Donald

Where do I put the formula?

Format > Conditional Formatting

Choose "formula is" from dropdown in left hand box and put the formula in the other box

Hit "format" button and choose red pattern,

this formula is sufficient

=MATCH(A2,$A$25:$F$25,0)