Macro to search for a value

[roberto1111]

Hello Friends,

I trying to make a macro that searches in column for a matching value of a specific cell.

Thank you for any help offered.


Greetings from Roberto, The Netherlands

[DonkeyOte]

No need for a macro here simply use Conditional Formatting on A1 with a formula of:

=MATCH(A1;D:D;0)
set font to Red

[roberto1111]

Hello DonkeyOte, thank you for your responding.

The Excel attachement is just a simple example.
I really need to use a macro for searching a specific values.


Greetings, Roberto

[DonkeyOte]

In which case I would advise posting a sample that reflects the complexities of your real requirements ... as things stand there is no justification for VBA, if you "need" VBA you will need to elaborate as to why as this will invariably affect the code logic.

[roberto1111]

Hello DonkeyOte,

I want to use a macro so I can let it run through multiple columns on different worksheets. This would work the best for me.

[DonkeyOte]

Not trying to repeat myself but...

...I would advise posting a sample that reflects the complexities of your real requirements ...