Macro find unknown words and mark containing cell

[forfiett]

Gday to all,

i need you help in making one macro on my excel workbook.
I want to make that it search for some words on sheet one in column C.
Words for search are listed on sheet two in column A. If are found some extra words non listed in sheet two column C i wan that it mark with some colour the cell containing "unknown" word.

PLS HELP

[Moo the Dog]

Your best bet would be to upload an example spreadsheet with sample data and expected results. Your description is a bit confusing - it would be easier if we could see what you were asking for.

It sounds like what you're asking could be done with Conditional Formatting. A macro wouldn't really be necessary.

- Moo

[forfiett]

i want that macro searches for words in colum C that are not listed in column A and than mark the cell containing unlisted word (with red colour).

in column A are allowed only words in column C. If in column A are words that are not listed in column C, the cells containing these words have to be marked with colour.

[Moo the Dog]

Then you could use Conditional Formatting:

Select the range of cells in column A (for example A2:A100) that you want to have checked, open the Conditional Formatting manager, create a new rule using a formula, and enter this formula:

=ISNUMBER(MATCH(A2,$C:$C,0))=FALSE

Then select a format you want shown and click OK once or twice to apply it.

If your range of cells in column C are on a different sheet, then you can use something like this, following the same procedure outlined above:

=ISNUMBER(MATCH(A2,'Name of your other sheet'!$C:$C,0))=FALSE

- Moo

[forfiett]

Thank you

it is possible to made a macro or something else that if in one column (expl A1) are values (expl...A,B,C) than in column B are allowed only values (expl D,F,M). If in column B are not allowed values (text) it mark the column with colour or something else.