Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Font and Fill ColorIndex
I want to set the font color index of a cell
to 'automatic' and the fill color to 'no fill'. I don't see the index number in the color chart in Excel's help. What are the Color Index #s for 'automatic' font and 'no fill' Thanks for your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Font and Fill ColorIndex
From VBA Help (Colorindex):
Font The color of the font. Specify xlColorIndexAutomatic to use the automatic color. Interior The color of the interior fill. Set this property to xlColorIndexNone to specify that you don't want an interior fill. In article , "Frank" wrote: I want to set the font color index of a cell to 'automatic' and the fill color to 'no fill'. I don't see the index number in the color chart in Excel's help. What are the Color Index #s for 'automatic' font and 'no fill' Thanks for your help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Font and Fill ColorIndex
Hi Frank,
You could record a macro to see what it does...I did it and you get a value of xlAutomatic and xlNone. These correspond to numeric values of -4105 and -4142 respectively. Hope this helps, Daniel Excel Tips and Tricks - www.danielklann.com "Frank" wrote in message ... I want to set the font color index of a cell to 'automatic' and the fill color to 'no fill'. I don't see the index number in the color chart in Excel's help. What are the Color Index #s for 'automatic' font and 'no fill' Thanks for your help |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Font and Fill ColorIndex
With ActiveCell
.Interior.ColorIndex = xlNone .Font.ColorIndex = xlAutomatic End With type colorindex in your module, highlight it an hit F1. This has that information. turn on the macro recorder and make those changes manually - then turn it off and look at the code - another way. -- Regards, Tom Ogilvy "Frank" wrote in message ... I want to set the font color index of a cell to 'automatic' and the fill color to 'no fill'. I don't see the index number in the color chart in Excel's help. What are the Color Index #s for 'automatic' font and 'no fill' Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DataLabel.Font.ColorIndex vs DataLabel.Text (Private Sub does not work in excel 2003) | Charts and Charting in Excel | |||
Changing font or fill-color when using formulae | Excel Discussion (Misc queries) | |||
can't see font colours and fill colour on screen | Setting up and Configuration of Excel | |||
Fill & Font colours have dissapeared | Excel Discussion (Misc queries) | |||
VBA syntax for Font & Interior ColorIndex | Excel Discussion (Misc queries) |