Hello,

Can somebody help me creating a Macro that can do as follows:

Search for a specific word in a specified column, for instance "red" of
"grey" and when this is found a row in another specified column a, b or c
must be marked with an x.

So, for instance:

a b c
1 red x
2 blue x
3 red x
4 gray x
5 gray x
6 blue x
7 red x

And the x-es will be put in automatically.

Thanks in advance!