View Single Post
  #2 (permalink)  
Old September 30th, 2004, 03:56 AM
gcianfanelli gcianfanelli is offline
Authorized User
 
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Use the Interior object, eg.

Code:
Selection.Interior.ColorIndex=5
Selection.Interior.Pattern=xlSolid
will set the current selection to blue

Also, you can play with the Font object if you need to change the colour of the text in a cell, eg.

Code:
Selection.Font.ColorIndex=5
or to set the first 3 characters of the active cell to blue would be

Code:
ActiveCell.Characters(1, 3).Font.ColorIndex=5
Reply With Quote