View Single Post
  #1   Report Post  
Marcin Wolku
 
Posts: n/a
Default 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..