Thought #1) Did you remember to use ctrl-shift-enter?
Thought #2) Try using vlookup and capture the 'not founds' with...
if(Isna(vlookup(...)),"No in other list","")

HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"sofiane b via OfficeKB.com" wrote:

i have tried the cpearson methods and conditional formatting wth colors but i
cant seem to have it working nothig happens..

i need to compare column A that has 1008 rows with column B that has 1031
rows and gives me the difference between the them or something in that area..
...

can someone help? thank you alot


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1