View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] motopoyo@spymac.com is offline
external usenet poster
 
Posts: 1
Default find word in a cell then change cell format

I want to find some words in cells

and then change the color of cell if find.

eg. a cell contain "hello I am moto"
if macro find "am" then change the cell color

anybody know how to write the macro ?
Thanks