Tricky comparing question
Use conditional formatting.
Select all of the imported data, let's assume it starts at A40
FormatConditional Formatting
Change Condition 1 to Formula Is
Enter the formula
=ISNUMBER(MATCH(A40,$A$2:$A$20,0))
Click format
Select the pattern tab
Choose a colour
OK out
That should work, change the cell references to suit.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Corben" wrote in message
...
I have my list of Criteria in Column A - (In this case the Criteria are
names)
In column B, C, D, and so on are days of the month.
I paste the raw data underneath the spreadsheet in the coresponding
columns.
So, day 1 is under column B. Day 2 under column C and so on.
I have formulas setup in the spreadsheet to count every time it sees the
name in the data for each day. Those formulas work great, so I dont want
to
change them.
Here is a small example of the layout.
A B C D E
Day 1 Day 2 Day 3 Day 4
John 1 0 1 1
Mark 2 0 0 0
Steve 0 3 1 0
Dan 0 0 1 1
John Steve John John <--This data is
pasted
from a text file
Mark Steve Dan Dan
Mark Steve Steve Jason
Notice that in column E, the name Jason is in the data, but not anywhere
in
column A. So there are 3 names in the data list, but only 2 are counted.
So I
would then have to insert a new row for Jason.
What I would like to do is to somehow compare the names after I paste the
data in, and if there is a name that is not in column A, then it would
point
that out - maybe changing the text color to red, or returning a value into
another cell.
Thank you in advance for any ideas.
|