Conditional formatting
 

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

Conditional formatting
 

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

Conditional formatting
 

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


"Toppers" wrote:

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

Conditional formatting
 

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

"Susan" wrote:

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


"Toppers" wrote:

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

Conditional formatting
 

Thank you! Much appreciated! Learned alot from your answer

"Toppers" wrote:

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

"Susan" wrote:

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


"Toppers" wrote:

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

Conditional formatting
 

Thank you for the feedback.

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

"Susan" wrote:

Thank you! Much appreciated! Learned alot from your answer

"Toppers" wrote:

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

"Susan" wrote:

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


"Toppers" wrote:

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