finding matching cells in worksheets
 

hello
i have to worksheets. in worksheet1 i have in column A list of cell which
contains descriptions . in 2 worksheet i have a data. 2 worksheet contains 3
columns. in columns C i have a list of data.
FOR EACH cell from sheet2 and column C i want to check . if cell contains
the same value as in any cell from sheet1 and column A, the value from
sheet2 column C and actual cell should stay without changes. if cell from
sheet2 contains data which isn't in sheet1 column A it should change the
font of the active cell and background color for red ...

so sheet1 is as a dictionary
sheet2 contains data which should be checked.
if cell from sheet 2 contains data which is include in sheet1 it should stay
without changes
if cell from sheet 2 constains data which isn't include in sheet1 it should
change the font and change background for red.

How can i do ??
please help me

wolku

SORRY for mistakes , I still learn english..

wolku,

You need to name column A from Sheet1 something - let's say "Test". Then select _all_ of column C
on Sheet2, and use

Format / Conditional formatting.... Select "Formula Is", and use the formula

=ISERROR(MATCH(C1,Test,FALSE))

Select your font and background, and click OK.

HTH,
Bernie
MS Excel MVP


"Marcin Wolku" wrote in message ...
hello
i have to worksheets. in worksheet1 i have in column A list of cell which contains descriptions .
in 2 worksheet i have a data. 2 worksheet contains 3 columns. in columns C i have a list of data.
FOR EACH cell from sheet2 and column C i want to check . if cell contains the same value as in any
cell from sheet1 and column A, the value from sheet2 column C and actual cell should stay without
changes. if cell from sheet2 contains data which isn't in sheet1 column A it should change the
font of the active cell and background color for red ...

so sheet1 is as a dictionary
sheet2 contains data which should be checked.
if cell from sheet 2 contains data which is include in sheet1 it should stay without changes
if cell from sheet 2 constains data which isn't include in sheet1 it should change the font and
change background for red.

How can i do ??
please help me

wolku

SORRY for mistakes , I still learn english..