Solved How to create a spreadsheet that highlights chosen numbers

July 11, 2012 at 00:09:03
Specs: Windows XP
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.

See More: How to create a spreadsheet that highlights chosen numbers

Report •

July 11, 2012 at 07:31:39
✔ Best Answer
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:


Sub Menu Format :
6) - Patterns
7) - Select a pretty color
8) - Press OK

See how that works.


Report •
Related Solutions

Ask Question