hi, in need a vb or macro to high light text marked in # to $ between in word EG,#AI1.a,Teka-Ann S. Haynes, AI2.a*,Valery Filippov, $#AI3.a.b,Maria Filippova, $#AI4.b,Jun Yang, $#AI5.a,Kangling Zhang, $#AI6.a,Penelope J. Duerksen-Hughes,$ #a1,Loma Linda University, Department of Basic Science,$#a2, Loma Linda University School of Medicine,$#a4, Loma Linda,$#a5, CA,$#a7, 92354 $#a6,USA$ #b1,Hangzhou Normal University, Department of Toxicology,$#b2, Hangzhou Normal University, School of Public Health,$#b4, Hangzhou,$#b5, Zhejiang,$#b7, 310036,$#b6, China$ $#AI7.c,Benjamin Albert, $#AI8.d,Isabelle Leger-Silvestre, $#AI9.d,Christophe Normand, $#AI10.d,Olivier Gadal,$

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

NEED TO HIGH LIGHT IN COLOR marked from # to $ in word

hi,

in need a vb or macro to high light text marked in # to $ between in word

EG,#AI1.a,Teka-Ann S. Haynes,

AI2.a*,Valery Filippov,
$#AI3.a.b,Maria Filippova,
$#AI4.b,Jun Yang,
$#AI5.a,Kangling Zhang,
$#AI6.a,Penelope J. Duerksen-Hughes,$
#a1,Loma Linda University, Department of Basic Science,$#a2, Loma Linda University School of Medicine,$#a4, Loma Linda,$#a5, CA,$#a7, 92354 $#a6,USA$
#b1,Hangzhou Normal University, Department of Toxicology,$#b2, Hangzhou Normal University, School of Public Health,$#b4, Hangzhou,$#b5, Zhejiang,$#b7, 310036,$#b6, China$
$#AI7.c,Benjamin Albert,
$#AI8.d,Isabelle Leger-Silvestre,
$#AI9.d,Christophe Normand,
$#AI10.d,Olivier Gadal,$