Font and Fill ColorIndex

Posted to microsoft.public.excel.programming

Frank[_19_] Frank[_19_] is offline

external usenet poster

Posts: 8

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DataLabel.Font.ColorIndex vs DataLabel.Text (Private Sub does not work in excel 2003)	God Itself	Charts and Charting in Excel	4	April 22nd 09 03:40 PM
Changing font or fill-color when using formulae	Phil	Excel Discussion (Misc queries)	1	April 4th 08 01:02 PM
can't see font colours and fill colour on screen	Susan	Setting up and Configuration of Excel	1	February 1st 08 07:05 AM
Fill & Font colours have dissapeared	Ferd	Excel Discussion (Misc queries)	1	October 23rd 07 09:43 PM
VBA syntax for Font & Interior ColorIndex	Dennis	Excel Discussion (Misc queries)	1	November 25th 04 07:38 PM

All times are GMT +1. The time now is 01:01 AM.

Menu

About Us