if letter change font also change

[gsrikanth]

1) §´ýÖçµ

2) §Ó´ýÖçµ

i have two words in the column in one cell either first come or the second word

if first word come change that cell font to times new roman
if second word come change to arial font how?



only we have find "Ó" letter in cell change the font

[gsrikanth]

Originally Posted by gsrikanth

1) §´ýÖçµ

2) §Ó´ýÖçµ

i have two words in the column in one cell either first come or the second word

if first word come change that cell font to times new roman
if second word come change to arial font how?

only we have find "Ó" letter in cell change the font

=if(find("Ó",a1,1)>0,With ActiveCell.Characters(Start:=1, Length:=end).Font
.Name = "Times new roman"
End With, (else),With ActiveCell.Characters(Start:=1, Length:=end).Font
.Name = "arial")