View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jasminesy jasminesy is offline
external usenet poster
 
Posts: 18
Default Color text inserted into other text

is it possible to color code text that will be inserted into other text:

asdf="HI"
if Range("a1")<"" then
tempval=Range("a1").value
Range("a1").ClearContents
Range("A1")=tempval & asdf


but I want "asdf" to be red (existing as is)???
Is there anyway to do that other than inserting it, searching it and then
color coding it??????