Press Alt+B in mIRC and the Address Book will appear. You'll see the Highlight tab, click on that.
First ensure the Enable HIghlight checkbox is checked, then click Add.
Add a word, select where to watch for it... Message (or nickname/both).
Choose a color (and sound file if you like).
Check the Flash and Tip boxes as you like.
Then OK and OK

See also /help highlight