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