Thread: Font color in the cells
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Font color in the cells
Check out

http://www.mvps.org/dmcritchie/excel/colors.htm


ActiveSheet.Range("A1:A10").Font.ColorIndex = 3



--
Jacob


"HuaMin" wrote:

Many thanks. I've tried the values 3, 4 for the index. But I don't see any
difference in the cell. How do we know which index is for which color?

"Jacob Skaria" wrote:

Range("A1:A10").Font.ColorIndex = 3

--
Jacob


"HuaMin" wrote:

Hi,
How about the way to change the color within VBA?

Bst Rgds,
HuaMin
Reply With QuoteReply With Quote