Compare and highlight EXCEL 2007

[nitinjoshi]

Hi guys

I know this has been answered gazillion times on the Internet, but for some reason i can't find a solution. I have two sheets. In both sheets, column A is called automotive and has a value underneath (like 876545). What i first wanted to do was compare two sheets to highlight the values that are not common. I couldn't do it so I used MATCH option to compare two columns A and B. The values that were not common returned #N/A in Column C. Now i want to highight the cells in column A that have corresponding #N/A in column C.
Conditional formatting doesn't work. I am using Excel 2007.

Thanks
NJ

[martindwilson]

use
=ISNA(C1) as the condition in a1

[nitinjoshi]

THANKS MATE!!!! it worked,,,