Comparing 2 list and Highlighting Values

[kr0nic]

Dear All,

I have a list of "expected guest" in column A. In column B, I will enter their ID as they "arrive".

I want excel to highlight in column A, those who have not arrived yet.

So initially column A will have all the expected guest names highlight. As I am entering names in column B, column A will commence unhighlighting the cells where people have arrived so at the end of the day, the names left still highlighted in column A did not turn up but were expected to.

In Column B, I will enter their names and will highlight entries that DO NOT match column A. Note that column B may have duplicate entries.


[TABLE="class: grid, width: 216"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]expected:[/TD]
[TD]arrived:[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]f[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]g[/TD]
[TD]g[/TD]
[/TR]
[TR]
[TD]h[/TD]
[TD]z[/TD]
[/TR]
[TR]
[TD]i[/TD]
[TD]y[/TD]
[/TR]
[TR]
[TD]j[/TD]
[TD]z[/TD]
[/TR]
</tbody>[/TABLE]


i.e column A, i and j are highlighted as they haven't arrived yet.

column B, z, y, x are highlighted because they are not on list on column A. (column B will have duplicate values )


many thanks for any suggestions, this has boggled me for ages.

 

[kr0nic]

Bump