Thread: Change cell color
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Simonds Patrick Simonds is offline
external usenet poster
  
Posts: 258
Default Change cell color
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