Conditional Formatting from 3 to 5
 

Hi

I need to set conditional formatting on 5 numbers to highlight any that
match another set of 5 numgers that will change week on week (lottery
numbers). I can set the conditional formatting to highlight any that match
the first 3 numbers, but not the next two.

Is there any way you can increase the conditions from 3 to 5?

Thanks Cathy