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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking entries against a column of data
y su
Start name-define ur refencelist as fx. List1 and List2 then select ur other list and insert this formula in cond.format =COUNTIF(List1;A1) ' change A1 to ur first cell in the range select color select add do the same just antoher color and user List2 here "TonyR" skrev: 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 |
Reply |
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 |