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..

finding matching cells in worksheets
 

You can do this with conditional formatting.

first you need to create a defined name for the data in the sheet1.

Insert=Name=Define
Name: List1
Refersto: =Sheet1!$A:$A

now go to column C in Sheet2 and select C2 down to the last cell in column C
(c1 if your data actually starts in row1). C2 should be the activecell in
the selected cells (reverse highlighting).

No do
Format=conditional Formation

in the first dropdown change it from "Cell Value is" to "Formula is"
in the textbox put in

=countif(List,$C2)=0

[if your activecell is C1, then change the formula to reflect C1]

then click the format button and select the formatting you want (font color
and/or background color)

then click the OK button and OK your way out of the Conditional Formatting
Dialog.

--
Regards,
Tom Ogilvy



"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..