compare lists
You're welcome, Jaleel - thanks for feeding back.
Pete
On Oct 13, 10:14*am, Jaleel wrote:
Hello,
Thanks Pete. *It is wonderful. *It will be of help to me in many cases.
Regards,
Jaleel
"Pete_UK" wrote:
The answer is yes.
Suppose you have a list in column A and another list in column C.
Highlight column A, so that A1 is the active cell and click on Format
| Conditional Formatting. Choose Formula Is rather than Cell Value Is
in the first box and enter this formula in the next box:
=NOT(ISNUMBER(MATCH(A1,C:C,0)))
Then click the Format button, then the Patterns tab (for background
colour) and choose your colour. OK your way out.
Then highlight column C and repeat with this formula:
=NOT(ISNUMBER(MATCH(C1,A:A,0)))
The highlighted items are not in both lists.
Hope this helps.
Pete
On Oct 13, 12:48 am, Jim S. wrote:
can excel compare two lists and highlight the items not on both lists?
--
J. Sorensen- Hide quoted text -
- Show quoted text -
|