I have one Excel list with two columns, NAME and GRADE, with about 400
records. This list of data is good for two weks after which time I receive
another Excel list with basically the same data from our Personnel
department. What I wish to do is to compare this new list against the
current list, and highlight any NAME and/or GRADE value differences in the
new list. The changed values on the new list will be used to update our
database. The lists can either be on seperate worksheets or next to each
other

Mark :)

comparing Two Ranges Name the Old Grades Range "OLD LIST"
The second list is New Grades Range "NEW LIST" Use Insert Range Define
command.
Select the cells in the OLD LIST range
Choose Format, Conditional Formatting, Choose Formula
=COUNTIF (NewList, A2)=0
Click format button specify the formatting to apply when the condition is true
A diffirent colored back ground is a good choice
Click OK
Note: This formula counts the # of times a value appears
try =B2 = C2 Then format the back ground --
If the ranges are in seperate books you will need to tell the formula where
the ranges are.

William<"M"




"NWO" wrote:

I have one Excel list with two columns, NAME and GRADE, with about 400
records. This list of data is good for two weks after which time I receive
another Excel list with basically the same data from our Personnel
department. What I wish to do is to compare this new list against the
current list, and highlight any NAME and/or GRADE value differences in the
new list. The changed values on the new list will be used to update our
database. The lists can either be on seperate worksheets or next to each
other

Mark :)

Thank you.

Didn't work.

OldList has two columns of data, NAME and GRADE. New List also has two
columns of data, NAME and GRADE. Now New List can have less or more records
than OLdList. What I want to happen is for every cell in the new list, check
the OldList for a matching value, if value dosn't match, then highlight cell.
So while the Name cell can match, the corresponding Grade cell may be
different on the new list, and I want that cell in the NewList to be
highlighted. NewList can also have new records (NAME and GRADE) that don;t
appear on the OldList, I want these cells highlighted also.

Thank you.

Mark


"Sunday88310" wrote:

comparing Two Ranges Name the Old Grades Range "OLD LIST"
The second list is New Grades Range "NEW LIST" Use Insert Range Define
command.
Select the cells in the OLD LIST range
Choose Format, Conditional Formatting, Choose Formula
=COUNTIF (NewList, A2)=0
Click format button specify the formatting to apply when the condition is true
A diffirent colored back ground is a good choice
Click OK
Note: This formula counts the # of times a value appears
try =B2 = C2 Then format the back ground --
If the ranges are in seperate books you will need to tell the formula where
the ranges are.

William<"M"




"NWO" wrote:

I have one Excel list with two columns, NAME and GRADE, with about 400
records. This list of data is good for two weks after which time I receive
another Excel list with basically the same data from our Personnel
department. What I wish to do is to compare this new list against the
current list, and highlight any NAME and/or GRADE value differences in the
new list. The changed values on the new list will be used to update our
database. The lists can either be on seperate worksheets or next to each
other

Mark :)