| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font color in the cells
Hi,
How about the way to change the color within VBA? Bst Rgds, HuaMin |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Font color in the cells
Range("A1:A10").Font.ColorIndex = 3
-- Jacob "HuaMin" wrote: Hi, How about the way to change the color within VBA? Bst Rgds, HuaMin |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Font color in the cells
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't change font color in certian cells. | Excel Discussion (Misc queries) | |||
| Counting cells by font color | Excel Discussion (Misc queries) | |||
| Changing font color of protected cells programatically | Excel Discussion (Misc queries) | |||
| Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
| keeping font color when linking cells | Excel Worksheet Functions | |||
![HuaMin[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
