Conditional Formatting

[Taych]

Hi,

Book1
	A	B	C	D
1	111		115
2	222		212
3	333		555
4	444		818
5	555		222
6	666		888
7	777		515
8	888		916
9	999		111
Sheet1

I am trying to highlight the numbers in Column A if they do not match those in Column C by using Conditional Formatting without success.

I use the formula =C1<>$A$1:$A$9 but did not get the right answer.

Any help will be most appreciated.

 

[Aladin Akyurek]

Try...

=ISNA(MATCH($A1,$C$1:$C$9,0))*($A1<>"")

 

[Taych]

Thanks Aladin, works like a charms.