Sub HighlightEleventhCharacter()
'Click on a cell and run the macro to "highlight" the 11th character
With ActiveCell.Characters(Start:=11, Length:=1).Font
.FontStyle = "Bold"
.Size = 14
.ColorIndex = 3
End With
End Sub

Vaya con Dios,
Chuck, CABGx3

"Excel_Newbie09"
wrote in
message news:Excel_Newbie09.25nzfa_1144027200.847@excelfor um-nospam.com...

Hey guys. I am new here and new to excel so go easy on me :)

I have a colum with 21 random characters in each cell. Is it possible
to find the 11th character in each cell within only that colum and to
make that character bold or red or something else so as to make it
stand out. Not sure if this could be done in excel so I thought I might
seek some expert help :D

Cheers


--
Excel_Newbie09
------------------------------------------------------------------------
Excel_Newbie09's Profile:
http://www.excelforum.com/member.php...o&userid=33094
View this thread: http://www.excelforum.com/showthread...hreadid=529050