Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking entries against a column of data
I have an excel spreadsheet that we use as an ongoing log of data,
within this data there is one specfic column that I want to check against a list of data and I am wondering if this is possible? Specifically, when the cell in this column is entered, can excel check that number against a set list of numbers within another row and turn the background color of that cell a different color if the number entered is found in the existing list of numbers in another row in the spreadsheet? If this is possible, can it be checked against 2 lists of numbers, returning a different color cell background depending on what list (if either) the number is found in? Any help would be greatly appreciated, Tony |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking for double entries | Excel Discussion (Misc queries) | |||
Checking for duplicate entries | Excel Discussion (Misc queries) | |||
Checking for duplicate entries over multiple worksheets | Excel Discussion (Misc queries) | |||
Finding duplicate cell entries in a column of data | Excel Discussion (Misc queries) | |||
checking celll in column | New Users to Excel |