Filter data from one collum by looking up from another column
Try something like this:
Using your posted example:
Select A1:A4, with A1 as the active cell
From the Excel main menu:
<format<conditional formatting
Formula is: =COUNTIF($A$1:$B1,A1)1
Click the [Format...] button and choose your settings
Click the [OK] buttons
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"mmaan" wrote:
Hi,
I am stuck on the following problem:
I want to exclude names (or give them another color) from 1 column if they
are also in another column.
To illustrate this, the result from the following data:
A B
1 John Peter
2 Sue Floyd
3 Peter Dan
4 Mike Chris
would have to be:
John
Sue
Mike
Or in this case I could use a conditional formatting to paint A3 red.
How do I do this?
|