Can you explain the data layout please.

Is it a column of names (say column A) with 5 columns of numbers (B to F)?

And where are the dawn numbers placed?

"Susan" wrote:

Hello,

Have a list of 150 people, who have chosen a set of 5 numbers. Each week
when a number is drawn and entered into a specific cell, need any like
numbers that have been chosen to turn RED, and stay red. Like bingo! But
cannot use a direct reference to a worksheet range using conditional
formatting.
Any ideas please? (not work related)
Thank you for your help.

Susan