Excel : AND, IF, RANDBETWEEN and conditional formatting

Part of a file I am working on. Here is a great one to do with your students. Set up a range of fixed Lotto numbers. The student must randomly generate numbers. If the numbers all match in sequence, they’re a winner! If some numbers match, make their cell colours match.