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" <[email protected]> wrote in message news:[email protected]...
> 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..
>
Bookmarks