Thread: Changing text color
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Changing text color
for a range
Range("A1").Font.ColorIndex = 3

--
Regards,
Tom Ogilvy

"Shannon" wrote in message
...
If the syntax (.Pattern = xlSolid) highlights a cell to
the color you select. What syntax changes the text color?


Reply With QuoteReply With Quote