Not sure if this is possible but we have created a syndicate at work with many members and I was just wondering if I was to list all individuals involved along with their chosen numbers is there a way to have 7 editable cells where each draws numbers are added and from that the added numbers will then be highlighted in the list of numbers next to peoples names? For example say you have names all in column A, then say you had everyone's chosen first number in column B, so in this column there will be a variety of numbers anywhere between 1 and 50, likewise the same will be said for columns C to H. Then what I would need would be for there to be 7 editable cells say I2 to O2 where you put in that week's numbers. Once you put these numbers in I would like the corresponding numbers to be highlighted by a colour in all of the columns between B and H.

With your Data looking like: A B C D E F G H I J K L M N O 1) Name/Nmbrs 1 2 3 4 5 6 7 2) schmams82 50 8 16 31 46 7 2

Don't know what version of Excel your using

so this is for 2000 & 2003:1) Highlight/Select Row 2, Column B to Column H

On the Menu Bar:

2) - Format

3) - Conditional Formatting

4) – Change “Cell Value is” to “Formula Is”

5) – Enter the formula:=COUNTIF($I$2:$O$2,B2)

Sub Menu Format :

6) - Patterns

7) - Select a pretty color

8) - Press OKSee how that works.

MIKE

Ask Your Question

Weekly Poll