Thread: Change cell color
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ElkySS ElkySS is offline
external usenet poster
  
Posts: 14
Default Change cell color
End With
Selection.Font.ColorIndex = 3

"Patrick Simonds" wrote:

How can I modify the code below to change the font color to red?

With ActiveCell

.Cells.Value = "9999"
.Offset(0, 0).EntireRow.Columns("D").Select

End With



Reply With QuoteReply With Quote