comparing data and conditional format

**buhnen** · 03-14-2010, 06:32 PM

Hello!

I have a very simple question. What formula/s would help me with achieving what I point out in the attached screen capture ?

Thanks in advance

**teylyn** · 03-14-2010, 06:44 PM

C2 =if(isna(match(b2,A2:A19,0)),"",b2)

copy down

Conditional formatting for column C with Formula IS

=NOT(ISNA(MATCH(B1,$A$1:$A$19,0)))

**buhnen** · 03-15-2010, 03:01 AM

Thank you very much teylyn

**teylyn** · 03-15-2010, 03:43 AM

buhnen, please don't quote whole posts. It's just clutter.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save