Conditional formatting

S

Susan

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
 
T

Toppers

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?
 
S

Susan

Hello, thank you for replying

Have bordered range next to the list, a couple of columns over.
You are correct on name setup.
Names in one column, their 6 number choices in the next 6 columns.
EX: Betty White, 4, 3, 6, 12, 32, 14
 
T

Toppers

Let's assume names in A, numbers in B to F, starting row 2; the numbers drawn
are in B1 to F1

Select B2:B200 (to allow for new names!)
CF
FormulaIs: =IF(B2<>"",OR(B2=$B$1,B2=$C$1,B2=$D$1,B2=$E$1,B2=$F$1))
Select colour (color!)

Repeat for columns D to F changing B2 reference to C2 etc

Try this and then adjust for actual situation.

HTH
 
T

Toppers

Thank you for the feedback.

These NGs are an excellent place for anyone (myself included!) to learn.
 
Top