Thread: How to color characters REG, GREEN, YELLOW in the same cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
mudraker[_146_] mudraker[_146_] is offline
external usenet poster
  
Posts: 1
Default How to color characters REG, GREEN, YELLOW in the same cell?
Adjust start, length & colourindex number to suit you needs


ActiveCell.Characters(Start:=1, Length:=5).Font.ColorIndex = 50
ActiveCell.Characters(Start:=6, Length:=2).Font.ColorIndex = 6
ActiveCell.Characters(Start:=8, Length:=3).Font.ColorIndex =

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote