Posts by amith swain

Re: Highlight Keywords cell

forum.ozgrid.com/index.php?attachment/64432/

i have attached an excel sheet were i have a few words which i need in the corresponding colors.

I want to create a macro where i can give around 50-100 keywords and when i run the macro it should highlight the entire cell in green and some 50 keywords which will be red.
Once i select the entire row and run the macro the cells containing the keyword should be highlighted.
So can you please help me out in doing this.
Thank You.