Macro to find matching words and highlight the row.

[satishk11]

I am totally new to excel macro programming.
I am attempting to do this with a macro.

1.Search a sheet for 6 medical words.
2.If 3 or more words are found , highlight the row in red.


Any advice.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[satishk11]

Thank You John , trying the macro.

does this macro work only with microsoft excel ?
will it work with libre office ?

get the error :
BASIC syntax error.
Unknown data type Range

[satishk11]

works thank you !!!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rules and mark this thread as SOLVED. See link for guidance.

http://www.excelforum.com/forum-rule...rum-rules.html