Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
How do I do conditional formatting? | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |