word search finder using conditional formatting

hi guys,
does anyone knows how to search words puzzle quickly using conditional formatting in excel?

okay,are there macros to do it?

Originally Posted by pejoi

okay,are there macros to do it?

Here you go. This works using your example grid.

Just highlight the 14 x 14 grid and press the button. It will search the word list from $A$3 down and also highlight the words it finds. Just to check I chnaged triangle to triangle1 and it doesn't highlight it. feel free to chnage the word list and the grid.

wow!!what's a genius crooza!!and one more question,how to change the grid by 21x21?please...

Make the grid as big as you want. Just select the 21 x 21 grid and highlight it before hitting the macro button. Just make sure your list of words starts in a3 and you're right to go.

If you try it and it doesn't work let me know

Oh and excuse the sloppy code. I cut and paste from another job I was working on.

Pejoi,

Try this slightly amended version that colour codes the words and letters for easier identification.

also has a reset button