ColorIndex Property

Microsoft Office Web Components Object Model

previous page next page

ColorIndex Property

ColorIndex property as it applies to the Border object.

Returns or sets the color of the border. The color is specified as an index value into the current color palette, or as a XlColorIndex constant. Read/write Variant.

XlColorIndex can be one of these XlColorIndex constants.

xlColorIndexAutomatic

xlColorIndexNone

expression.ColorIndex

expression Required. An expression that returns a Border object.

ColorIndex property as it applies to the Borders object.

Returns or sets the color of all four borders. The color is specified as an index value into the current color palette, or as a XlColorIndex constant. Returns Null if all four borders aren't the same color. Read/write Variant.

XlColorIndex can be one of these XlColorIndex constants.

xlColorIndexAutomatic

xlColorIndexNone

expression.ColorIndex

expression   Required. An expression that returns a Borders object.

ColorIndex property as it applies to the Font object.

Returns or sets the color of the font. The color is specified as an index value into the current color palette, or as XlColorIndex constant. Read/write Variant.

XlColorIndex can be one of these XlColorIndex constants.

xlColorIndexAutomatic

xlColorIndexNone

expression.ColorIndex

expression   Required. An expression that returns a Font object.

ColorIndex property as it applies to the Interior object.

Returns or sets the color of the interior fill. The color is specified as an index value into the current color palette, or as a XlColorIndex constant. Read/write Variant.

XlColorIndex can be one of these XlColorIndex constants.

xlColorIndexAutomatic

xlColorIndexNone

expression.ColorIndex

expression   Required. An expression that returns a Interior object.

Remarks

This property specifies a color as an index into the workbook color palette. You can use the Colors method to return the current color palette.

The following illustration shows the color-index values in the default color palette.

Example

As it applies to the Font object.

This example changes the font color in cell A1 on Sheet1 to red.

Spreadsheet1.ActiveSheet.Range("A1").Font.ColorIndex = 3

previous page start next page

Menu Homepage Table of contents Microsoft Office Web Components Object Models What's New for Microsoft Office Web Components Developers Programming Concepts Microsoft Office Chart Workspace Examples Declaring and Using Event Procedures in VBScript Using Named Constants in VBScript Objects A-B AllGroupingDefs Collection Object AllPageFields Collection Object AutoFilter Object Border Object Borders Collection Object ByRef Object C ChartSpace Object ChAxes Collection ChAxis Object ChBorder Object ChCategoryLabel Object ChCategoryLabels Collection ChChart Object ChChartDraw Object ChChartField Object ChChartFields Object ChCharts Collection ChDataLabel Object ChDataLabels Object ChDataLabelsCollection Collection ChDropZone Object ChErrorBars Object ChErrorBarsCollection Object ChFont Object ChFormatMap Object ChGridlines Object ChInterior Object ChLegend Object ChLegendEntries Collection ChLegendEntry Object ChLine Object ChMarker Object ChPlotArea Object ChPoint Object ChPoints Collection ChScaling Object ChSegment Object ChSegmentBoundary Object ChSegments Object ChSeries Object ChSeriesCollection Collection ChSurface Object ChTitle Object ChTrendline Object ChTrendlines Collection ChUserDefinedSelection Object Coordinate Object Criteria Object D-E DataPage Object DataPages Collection Object DataSourceControl Object DSCEventInfo Object ElementExtension Object ElementExtensions Collection Object F-G Filter Object Filters Collection Object Font Object GroupingDef Object GroupingDefs Collection Object GroupLevel Object GroupLevels Collection Object H-L Heading Object Headings Object Hyperlink Object Interior Object LookupRelationships Collection Object LookupSchemaRelationships Collection Object N-O Name Object Names Collection OCCommand Object OCCommands Object OWCLanguageSettings Object P PageField Object PageFields Collection Object PageRelatedField Object PageRelatedFields Collection Object PageRelationship Object PageRowsource Object PageRowsources Collection Object Pane Object Panes Collection Object ParameterValue Object ParameterValues Collection Object PivotAggregate Object PivotAggregates Collection Object PivotAxis Object PivotAxisMember Object PivotAxisMembers Collection PivotCell Object PivotColumnMember Object PivotColumnMembers Collection PivotData Object PivotDataAxis Object PivotDetailCell Object PivotDetailRange Object PivotField Object PivotFields Collection Object PivotFieldSet Object PivotFieldSets Collection Object PivotFilterAxis Object PivotFont Object PivotGroupAxis Object PivotHyperlink Object PivotLabel Object PivotMember Object PivotMemberProperties Collection PivotMemberProperty Object PivotMembers Collection Object PivotPageMember Object PivotPageMembers Collection PivotRange Object PivotResultAxis Object PivotResultColumnAxis Object PivotResultDataAxis Object PivotResultField Object PivotResultFilterAxis Object PivotResultGroupAxis Object PivotResultGroupField Object PivotResultGroupFields Collection PivotResultLabel Object PivotResultMemberProperties Collection PivotResultMemberProperty Object PivotResultPageAxis Object PivotResultRowAxis Object PivotRowMember Object PivotRowMembers Collection PivotTable Object PivotTotal Object PivotTotals Collection Object PivotView Object Protection Object R-S Range Object RecordNavigationControl Object RecordsetDef Object RecordsetDefs Collection Object SchemaField Object SchemaFields Collection Object SchemaParameter Object SchemaParameters Collection Object SchemaRelatedField Object SchemaRelatedFields Collection Object SchemaRelationship Object SchemaRelationships Collection Object SchemaRowsource Object SchemaRowsources Collection Object Section Object Sheets Collection Spreadsheet Object SublistRelationships Collection Object SublistSchemaRelationships Collection Object T-W TitleBar Object Window Object Windows Collection Object Workbook Object Workbooks Collection Worksheet Object Worksheets Collection Methods A Activate Method Add Method AddCalculatedField Method AddCalculatedTotal Method AddCustomGroupField Method AddCustomGroupMember Method AddFieldSet Method AddIn Method AddNew Method AddTotal Method Apply Method ApplyFilter Method AutoFilter Method AutoFit Method AutoLayout Method B-C BeginObject Method BeginUndo Method BorderAround Method Calculate Method CalculateFull Method Clear Method ClearContents Method ClearFormats Method Collapse Method Copy Method CopyFromRecordset Method Cut Method D Delete Method DeleteCustomGroupMember Method DeleteField Method DeleteFieldSet Method DeleteRecord Method DeleteTotal Method DrawEllipse Method DrawLine Method DrawPolygon Method DrawPolyLine Method DrawRectangle Method DrawText Method DropZones Method DuplicateFormat Method E EndEdit Method EndObject Method EndUndo Method EuroConvert Method Evaluate Method Execute Method Expand Method Export Method ExportPicture Method ExportXML Method F FillDown Method FillRight Method Find Method FindNext Method FindPrevious Method FlipHorizontal Method FlipVertical Method Follow Method G-H GetContainingSection Method GetPicture Method GetValue Method Group Method HideDetails Method I Insert Method InsertFieldSet Method InsertTotal Method IsButtonEnabled Method Item Method L-M LargeScroll Method Load Method LoadText Method MakeCurrent Method Merge Method Move Method MoveDetailLeft Method MoveDetailTop Method MoveFirst Method MoveLast Method MoveLeft Method MoveNext Method MovePrevious Method MoveTop Method N-P NewRecord Method Nz Method ParseText Method Paste Method PointsToScreenPixelsX Method PointsToScreenPixelsY Method Protect Method R RangeFromPoint Method RectIntersect Method RectUnion Method Refresh Method RefreshJetCache Method RemoveFieldSet Method RemoveTotal Method Repaint Method Requery Method Reset Method ResetColors Method ResetHeadings Method RotateClockwise Method RotateCounterClockwise Method S Save Method ScrollIntoView Method Select Method SetData Method SetOneColorGradient Method SetPatterned Method SetPresetGradient Method SetRootRecordset Method SetSolid Method SetSpreadsheetData Method SetTextured Method SetTwoColorGradient Method Show Method ShowAbout Method ShowAllData Method ShowContextMenu Method ShowDetails Method ShowHelp Method SmallScroll Method Sort Method SortAscending Method SortDescending Method StartEdit Method T-V TextHeight Method TextWidth Method ToggleFilter Method Undo Method Ungroup Method UnMerge Method Unprotect Method UpdatePropertyToolbox Method ValueToPoint Method Properties A ActiveCell Property ActiveData Property ActiveObject Property ActivePane Property ActiveSheet Property ActiveView Property ActiveWindow Property ActiveWorkbook Property Address Property Aggregates Property AllGroupingDefs Property AllIncludeExclude Property AllMember Property AllowAdditions Property AllowCustomOrdering Property AllowDeletingColumns Property AllowDeletingRows Property AllowDeletions Property AllowDetails Property AllowEdits Property AllowFiltering Property AllowFormattingColumns Property AllowFormattingRows Property AllowGrouping Property AllowHeadingRename Property AllowInsertingColumns Property AllowInsertingRows Property AllowLayoutEvents Property AllowMultiFilter Property AllowPointRenderEvents Property AllowPropertyToolbox Property AllowRenderEvents Property AllowScreenTipEvents Property AllowSorting Property AllPageFields Property AlternateDataSource Property AlternateRowColor Property AlwaysIncludeInCube Property AmbientLightIntensity Property Amount Property Application Property AspectRatio Property AutoFilter Property AutoFilterMode Property AutoFit Property Axes Property Axis Property B BackColor Property BackWall Property BaseName Property Begin Property Bold Property Bookmark Property Border Property Borders Property Bottom Property BottomRight Property BoundField Property BubbleScale Property Build Property BuildNumber Property ButtonBorder Property ButtonFont Property ButtonInterior Property C Calculation Property CalculationVersion Property CanUndo Property Caption Property CaptionHAlignment Property CaptionSection Property CategoryLabels Property Cell Property Cells Property CellsEx Property ChartDepth Property ChartFields Property ChartLayout Property Charts Property ChartSpaceLegend Property ChartSpaceTitle Property ChartWrapCount Property Checked Property ChildAxisMembers Property ChildColumnMembers Property ChildLabel Property ChildMembers Property ChildPageMembers Property ChildRowMembers Property ChildSection Property Color Property ColorIndex Property Colors Property Column Property ColumnAxis Property ColumnHeadings Property ColumnMember Property ColumnMembers Property Columns Property ColumnWidth Property Commands Property CommandText Property CompareMemberCaptionsBy Property CompareOrderedMembersBy Property Connection Property ConnectionFile Property ConnectionString Property Constants Property ConsumesRecordset Property Control Property ControlSource Property Count Property Criteria Property Crosses Property CrossesAtValue Property CrossingAxis Property CSVData Property CSVURL Property CurrentArray Property CurrentCell Property CurrentRegion Property CurrentSection Property CustomGroupMembers Property CustomGroupType Property D DashStyle Property Data Property DataAxis Property DataEntry Property DataField Property DataLabel Property DataLabelsCollection Property DataMember Property DataPage Property DataPages Property DataPageSize Property DataSource Property DataSourceName Property DataSourceType Property DataType Property DefaultColor Property DefaultControlType Property DefaultMember Property DefaultRecordset Property DefaultSort Property DefaultValue Property DesignMode Property DetailAutoFit Property DetailBackColor Property DetailCells Property DetailColumnCount Property DetailFont Property DetailForeColor Property DetailHAlignment Property DetailLeft Property DetailLeftOffset Property DetailMaxHeight Property DetailMaxWidth Property DetailRange Property DetailRowCount Property DetailRowHeight Property DetailsExpanded Property DetailSortOrder Property DetailTop Property DetailTopOffset Property DetailWidth Property Direction Property DirectionalLightInclination Property DirectionalLightIntensity Property DirectionalLightRotation Property Dirty Property DisplayAlert Property DisplayAlerts Property DisplayCalculatedMembers Property DisplayColumnHeadings Property DisplayCustomHeadings Property DisplayDesignTimeUI Property DisplayEmptyMembers Property DisplayExpandIndicator Property DisplayFieldButtons Property DisplayFieldList Property DisplayGridlines Property DisplayHeadings Property DisplayHorizontalScrollBar Property DisplayIn Property DisplayInFieldList Property DisplayOfficeLogo Property DisplayPropertyToolbox Property DisplayRowHeadings Property DisplayScreenTips Property DisplayTitleBar Property DisplayToolbar Property DisplayTotal Property DisplayVerticalScrollBar Property DisplayWorkbookTabs Property DisplayZeros Property Divisions Property DrawType Property E EditMode Property ElementExtensions Property ElementID Property EnableAutoFilter Property Enabled Property EnableEvents Property EnableResize Property EnableUndo Property End Property EndStyle Property EntireColumn Property EntireRow Property Error Property ErrorBarsCollection Property ExcludedMembers Property ExpandDetails Property Expanded Property ExpandedByDefault Property ExpandMembers Property Explosion Property Expression Property ExtrudeAngle Property F Field Property FieldLabelBackColor Property FieldLabelFont Property FieldLabelForeColor Property FieldLabelHeight Property Fields Property FieldSet Property FieldSets Property FieldType Property FillType Property Filter Property FilterAxis Property FilterCaption Property FilterContext Property FilterCrossJoins Property FilterFunction Property FilterFunctionValue Property FilterMode Property FilterOn Property FilterOnScope Property Filters Property FindAxisMember Property FindColumnMember Property FindMember Property FindPageMember Property FindRowMember Property FirstSection Property FirstSliceAngle Property Floor Property Font Property FontName Property ForeColor Property Format Property FormatMap Property Formula Property FormulaArray Property FormulaLocal Property FreezePanes Property Function Property G GapDepth Property GapWidth Property GradientDegree Property GradientStyle Property GradientVariant Property GridlineColor Property GridlineColorIndex Property GridX Property GridY Property GroupedAutoFit Property GroupedBackColor Property GroupedFont Property GroupedForeColor Property GroupedHAlignment Property GroupedHeight Property GroupedWidth Property GroupEnd Property GroupField Property GroupFields Property GroupFilterControl Property GroupFilterField Property GroupFooter Property GroupHeader Property GroupingDefs Property GroupingTotalFunction Property GroupingType Property GroupingUnit Property GroupingUnitType Property GroupInterval Property GroupLevel Property GroupLevels Property GroupOn Property GroupStart Property H HAlignment Property HasAbsoluteLabels Property HasArray Property HasAutoAspectRatio Property HasAutoCaption Property HasAutoChartDepth Property HasAutoDivisions Property HasAutoMajorUnit Property HasAutoMaximum Property HasAutoMinimum Property HasAutoMinorUnit Property HasBubbleSize Property HasCategoryName Property HasChartSpaceLegend Property HasChartSpaceTitle Property HasDetails Property HasDiscreteDivisions Property HasFormula Property HasLegend Property HasMajorGridlines Property HasMinorGridlines Property HasMultipleCharts Property HasPassiveAlerts Property HasPercentage Property HasPlotDetails Property HasRuntimeSelection Property HasSelectionMarks Property HasSeriesByRows Property HasSeriesName Property HasSplit Property HasTickLabels Property HasTitle Property HasUnifiedScales Property HasValue Property HeaderBackColor Property HeaderFont Property HeaderForeColor Property HeaderHAlignment Property HeaderHeight Property Height Property HeightRatio Property Hidden Property HoleSize Property HorizontalAlignment Property HTMLContainer Property HTMLData Property HTMLURL Property Hwnd Property Hyperlink Property I id Property Inclination Property Include Property IncludedMembers Property Index Property Interior Property InternalPivotTable Property International Property IsConsistent Property IsDataBound Property IsDirty Property IsDisplayingEquation Property IsDisplayingRSquared Property IsExpanded Property IsFiltered Property IsFilterOn Property IsHyperlink Property IsIncluded Property IsTotal Property IsValid Property Italic Property Item Property ItemCount Property J-L JoinType Property Label Property LanguageID Property LanguagePreferredForEditing Property LanguageSettings Property Left Property Left2 Property LeftOffset Property Legend Property LegendEntries Property Length Property Level Property LevelCount Property LightNormal Property Line Property LineStyle Property ListBoundField Property ListDisplayField Property ListRowSource Property Location Property Locked Property LogBase Property LookupRelationships Property LookupSchemaRelationships Property M MajorGridlines Property MajorTickMarks Property MajorUnit Property MajorVersion Property ManySide Property Marker Property MaxHeight Property Maximum Property MaxRecords Property MaxWidth Property Member Property MemberCaptions Property MemberProperties Property MemberPropertiesOrder Property MemberProperty Property MergeArea Property MergeCells Property Minimum Property MinorGridlines Property MinorTickMarks Property MinorUnit Property MinorVersion Property Miter Property MoveAfterReturn Property MoveAfterReturnDirection Property N Name Property Names Property Next Property NextSection Property NextSibling Property NumberFormat Property NumericScale Property O ObjectType Property Offline Property OfflinePublication Property OfflineSource Property OfflineType Property Offset Property OneSide Property Order Property OrderedMembers Property Orientation Property Overlap Property P PageAxis Property PageFields Property PageMember Property PageRelatedFields Property PageRowsource Property PageRowsources Property Panes Property ParameterValues Property Parent Property ParentAxisMember Property ParentColumnMember Property ParentLabel Property ParentMember Property ParentPageMember Property ParentRecordsetDef Property ParentRowMember Property ParentSection Property Path Property Pattern Property PercentComplete Property Period Property Perspective Property PivotAxis Property PivotObject Property PlotAllAggregates Property PlotArea Property Points Property Position Property Precision Property PrefixCharacter Property PresetGradientType Property PresetTexture Property Previous Property PreviousSection Property PreviousSibling Property PrimaryPageRowsource Property PrintQuality3D Property ProjectionMode Property PropertyCaptionFont Property PropertyCaptionHAlignment Property PropertyCaptionWidth Property PropertyHeight Property PropertyValueFont Property PropertyValueHAlignment Property PropertyValueWidth Property ProtectContents Property Protection Property ProtectionMode Property ProtectStructure Property ProviderFormattedValue Property ProviderType Property R Range Property RangeSelection Property ReadingOrder Property RecordNavigationSection Property RecordSelector Property Recordset Property RecordsetDef Property RecordsetDefs Property RecordsetLabel Property RecordsetType Property RecordSource Property RefersTo Property RefersToLocal Property RefersToRange Property ResyncCommand Property ReturnValue Property RevisionNumber Property Right Property RightToLeft Property Rotation Property Row Property RowAxis Property RowHeadings Property RowHeight Property RowMember Property RowMembers Property Rows Property S Scaling Property Scalings Property SchemaFields Property SchemaParameters Property SchemaRelatedFields Property SchemaRelationships Property SchemaRowsources Property ScreenUpdating Property ScrollColumn Property ScrollRow Property Section Property Segments Property SelectedSheets Property Selection Property SelectionType Property Separator Property SeriesCollection Property ServerFilter Property Sheets Property ShowAll Property ShowAs Property ShowAsValue Property ShowDelButton Property ShowFilterBySelectionButton Property ShowFirstButton Property ShowHelpButton Property ShowLabel Property ShowLastButton Property ShowNewButton Property ShowNextButton Property ShowPrevButton Property ShowSaveButton Property ShowSortAscendingButton Property ShowSortDescendingButton Property ShowToggleFilterButton Property ShowUndoButton Property SideWall Property Size Property SizeRepresents Property SolveOrder Property SortDirection Property SortOn Property SortOnScope Property Source Property SourceAxis Property SourceColumnAxis Property SourceDataAxis Property SourceField Property SourceFilterAxis Property SourceLabel Property SourceMember Property SourcePageAxis Property SourceRowAxis Property SplitMaximum Property SplitMinimum Property StandardHeight Property StandardWidth Property Status Property Style Property Subaddress Property SublistRelationships Property SublistSchemaRelationships Property SubtotalBackColor Property SubtotalFont Property SubtotalForeColor Property SubtotalLabelBackColor Property SubtotalLabelFont Property SubtotalLabelForeColor Property SubtotalLabelHAlignment Property Subtotals Property T TabRatio Property Text Property TextureFormat Property TextureName Property TexturePlacement Property TextureStackUnit Property Thickness Property TickLabelSpacing Property TickLabelUnitType Property TickMarkSpacing Property TickMarkUnitType Property TimeValue Property TipText Property Title Property TitleBar Property Toolbar Property Top Property Top2 Property TopLeft Property TopOffset Property Total Property TotalAllMembers Property TotalBackColor Property TotalColumnMember Property TotalFont Property TotalForeColor Property TotalMember Property TotalOrientation Property TotalPageMember Property TotalRowHeight Property TotalRowMember Property Totals Property TotalType Property Trendlines Property Type Property U Underline Property UniqueName Property UniqueTable Property UsableHeight Property UsableWidth Property UsedRange Property UseRemoteProvider Property UserMode Property UseStandardHeight Property UseStandardWidth Property UseXMLData Property V Value Property Value2 Property ValueType Property Version Property VerticalAlignment Property View Property ViewableRange Property ViewOnlyMode Property ViewportLeft Property ViewportTop Property Visible Property VisibleRange Property W WatermarkBorder Property WatermarkFont Property WatermarkInterior Property Weight Property Width Property WidthRatio Property WindowNumber Property Windows Property Workbooks Property Worksheet Property Worksheets Property X-Z X Property XMLData Property XMLDataTarget Property XMLLocation Property XMLURL Property Y Property ZOrder Property Events A AfterDelete Event AfterFinalRender Event AfterInsert Event AfterLayout Event AfterRender Event AfterUpdate Event B BeforeCollapse Event BeforeContextMenu Event BeforeDelete Event BeforeExpand Event BeforeFirstPage Event BeforeInitialBind Event BeforeInsert Event BeforeKeyDown Event BeforeKeyPress Event BeforeKeyUp Event BeforeLastPage Event BeforeNextPage Event BeforeOverwrite Event BeforePreviousPage Event BeforeQuery Event BeforeRender Event BeforeScreenTip Event BeforeUpdate Event ButtonClick Event C Change Event Click Event CommandBeforeExecute Event CommandChecked Event CommandEnabled Event CommandExecute Event CommandTipText Event Current Event D DataChange Event DataError Event DataPageComplete Event DataSetChange Event DblClick Event Dirty Event E-K EndEdit Event Focus Event Initialize Event KeyDown Event KeyPress Event KeyUp Event L-M LoadCompleted Event MouseDown Event MouseMove Event MouseOut Event MouseOver Event MouseUp Event MouseWheel Event O-R OnConnect Event OnDisconnect Event PivotTableChange Event Query Event RecordExit Event RecordsetSaveProgress Event S-V SelectionChange Event SelectionChanging Event SheetActivate Event SheetCalculate Event SheetChange Event SheetDeactivate Event SheetFollowHyperlink Event StartEdit Event Undo Event ViewChange Event Get in touch Submit feedback about this site to: [email protected] © documentation.help. Design: rehmann.co.