Selecting Font Colors - beyond the 40 palate or 16 additional in the Format Cells dialog

Greetings group, my 1st post here.

I've been trying to figure out how to use/create additional text font colors 
beyond the 40 palate or 16 additional in the Format Cells dialog.

Is this possible?  Is there a show codes area to tweak?  or better still a 
color wheel for the Text Font Color available.

I'm using: Microsoft(R) Office Excel 2003 (11.8012.6568) SP2

- thanks in advance M.D. 


0
mdetomaso (2)
7/6/2006 12:14:36 AM
excel 39879 articles. 2 followers. Follow

2 Replies
487 Views

Similar Articles

[PageSpeed] 53

About all you can do is modify the existing colors under
Tools>Options>Colors>Modify.

This is not a global change, just a workbook by workbook basis.

You can import your modified scheme from one book to another.

This also changes the background colors..same palette.


Gord Dibben  MS Excel MVP

On Thu, 06 Jul 2006 00:14:36 GMT, "Michael De Tomaso" <mdetomaso@bak.rr.com>
wrote:

>Greetings group, my 1st post here.
>
>I've been trying to figure out how to use/create additional text font colors 
>beyond the 40 palate or 16 additional in the Format Cells dialog.
>
>Is this possible?  Is there a show codes area to tweak?  or better still a 
>color wheel for the Text Font Color available.
>
>I'm using: Microsoft(R) Office Excel 2003 (11.8012.6568) SP2
>
>- thanks in advance M.D. 
>

0
Gord
7/6/2006 12:21:47 AM
Gord,

Thanks for the simple work-a-round.  Even got a color wheel to boot :)

10/4 M.D.

"Gord Dibben" <gorddibbATshawDOTca> wrote in message 
news:4oloa2l1brvqmf0onrltg5d5pst113k7h9@4ax.com...
> About all you can do is modify the existing colors under
> Tools>Options>Colors>Modify.
>
> This is not a global change, just a workbook by workbook basis.
>
> You can import your modified scheme from one book to another.
>
> This also changes the background colors..same palette.
>
>
> Gord Dibben  MS Excel MVP
>
> On Thu, 06 Jul 2006 00:14:36 GMT, "Michael De Tomaso" 
> <mdetomaso@bak.rr.com>
> wrote:
>
>>Greetings group, my 1st post here.
>>
>>I've been trying to figure out how to use/create additional text font 
>>colors
>>beyond the 40 palate or 16 additional in the Format Cells dialog.
>>
>>Is this possible?  Is there a show codes area to tweak?  or better still a
>>color wheel for the Text Font Color available.
>>
>>I'm using: Microsoft(R) Office Excel 2003 (11.8012.6568) SP2
>>
>>- thanks in advance M.D.
>>
> 


0
mdetomaso (2)
7/6/2006 12:47:40 AM
Reply:

Similar Artilces:

File Format is not valid
I have an Excel SpreadSheet that was created last November which for some reason we can no longer open. I have tried to restore from backup all the way back into November but get the same error: File Format is not valid We had been able to get into the file up until recently. Thanks for the help. try to open in a different version of excel like xl2002 -- Don Guillett SalesAid Software donaldb@281.com "Patriot" <mannyg@satx.rr.com> wrote in message news:e3yWOsWqDHA.2312@TK2MSFTNGP12.phx.gbl... > I have an Excel SpreadSheet that was created last November which for some...

Overwriting Cells
I cannot seem to get the "Alert Before Overwriting Cells" option to work. Although I have the box checked I can overwrite non-empty cells without a message. Can someone please help??? That warning is only for drag and drop operations. With the option selected make an entry in A1 and in A2. Drag A1 on top of A2. You should get a warning. -- Jim Rech Excel MVP "Keith bedford" <Keithbedford@discussions.microsoft.com> wrote in message news:FF296433-A0DF-4C98-8711-B414BAE2655A@microsoft.com... |I cannot seem to get the "Alert Before Overwriting Cells" ...

Conditional Formatting "Duplicate Values"
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am using Excel to enter pipe numbers, on my PC I can use duplicate values to highlight the cell if a duplicate value is entered. Unfortunately I have not been able to figure out how to do this in EXCEL 2008 on my MAC. Not enough detail to answer. Basically, you do it the same in Excel 2008 as you do on the PC. Search for "duplicate" in the Excel Help and it shows two techniques. Give me more detail on what you need and we can be more help. On 6/06/10 12:45 PM, in article 59bb96fd.-1@we...

how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel
I have a spreadsheet that the data, the date was input in Excel 2003 as mm/dd/yyyy (12/31/2004), how can I convert the column of cells format to "dd:mm:yyyy"(31:12:2004)? I tried to change date format from "Format Cells----choose "date" or "custom" and tried different options, but they wouldnt change the data already in the cells. I have a spreadsheet that Microsoft is requesting information in dd:mm:yyyy (yes colons) format. Thanks Jack How about =TEXT(SUBSTITUTE(E1,":","/"),"dd/mm/yy") assuming date in E1 VB...

saving values to cells
ok here goes... what i was wondering is hard to explain so ill explain it in an smal example... i have 3 sheets in my workbook, 'week1', 'week2' and 'total' i enter the number 10 in cell A1 on the 'week1' sheet and the number in cell B2 on the 'week2' sheet on the 'total' sheet in cell C3 i enter the formula =week1!A1+week2!B and it adds it obviously. but i then want to delete sheets 'week1' and 'week2' yet keep the valu 13 in cell C3 on the 'total' sheet WITHOUT having to type it in myself. ignore the macro part i...

Cell formating #5
If one cell in a spreadsheet has a specific format (font, color, etc..) and I have another cell that will equal that cell with an if formula, how do I retain the formatting of the original cell in the cell with the result? Hi! You would have to do that through conditional formatting or manually format the cell with the formula in it. A formula will only return a value from another cell and not that other cells formatting. Biff >-----Original Message----- >If one cell in a spreadsheet has a specific format (font, color, etc..) and I >have another cell that will equal that ce...

What is the column width associated with cell borders?
It appears that there is a 1/2 pt border between columns. Is that correct? If I merge 3 standard 8.43 pt width cells (A1:C1) and wrap text, the text wrap appears to be the same as if it were one cell with a column width 26.29 instead of 25.29. If I go to Format>Cells>Border the line style is represented visually, but in Word the default line style for a table border is 1/2 pt. Also, is I use a cell border that is thicker than default, does that reduce the space available in the cell or increase the spacing between cells? Thanks for your help, Bob Bob - The number format you...

Conditional Formatting...Please Advise
If I have a row of cells B6:M6 A cell K6 which is "List" validated Yes, No I would like the full range of cells B6:M6 to become Yellow, when the cell is set to Yes from the list. I have experimanted with the "Conditional Formatting" dialogue box, but can't work out how to do this....I can only get one cell to change to yellow....that being K6 if I select yes from the list. Please advise the correct way for me to achieve this objective. Thanks If you choose 'cell value is' in the first drop-down of the CF dialog, then you can only adjust the current cell&...

need help deleting space in cell with data
I have pasted a 1000 dates in the format mm/yyyy However, when pasted in, the dates all have a space at the end of the last c harachter. I want to delete that space so Excel recognizes field as a date. The trim function seems to be only for text. Can anyone provide a solutio n? Any help would be great. Thank you in advance. -- andrewsolomon ------------------------------------------------------------------------ andrewsolomon's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24050 View this thread: http://www.excelforum.com/showthread.php?threadid=376583 ...

Can I reverse the order of data in a set of cells?
I have a column of cells filed with data. I know I can transpose the data 90 degrees, but is there a way to cut or copy the data in the cells and paste it so the values are in the opposite order, i.e. a 180 degree difference? Thanks to anyone who can help. I am using Excel 2003. One way, insert a new column or use an existing, number it from 1 - n (where n is the last index value you want to reverse the order of, so if your column is 100 rows number the help column 1, 2, 3 - 100) select both columns and sort descending on the help column -- Regards, Peo Sjoblom "salwitt"...

excel will not print in color 2007
how do I get the colors set up on the page to print? My printer does color and I did not have this problem with the 2003 version Bill [email Wrote: > billke2u0@aol.com[/email];699652]how do I get the colors set up on the page to print? My printer does color > and I did not have this problem with the 2003 version Go to print properties inside excel print menu and check to see if the printer is set to text only. -- Dianne ------------------------------------------------------------------------ Dianne's Profile: http://www.thecodecage.com/foru...

need to copy cell refs with different incrementation
I need to copy a range of cells, and some of them have references t cells on another worksheet, but the cells with references are no contiguous, nor are the referenced cells. I have tried the fill handl to duplicate, and it does it partially correct, but not completely. Example: B7 contains cell reference =eb!A4 (eb is the name of the othe worksheet), and C9 contains cell reference =eb!B5. Cell B10 contain the cell reference =eb!A8, and C12 contains =eb!B9. I want to cop these six cells over and over down the page. The problem is that I need the B cells to increment the number by thre o...

Can VLookup pull text format from data
Hello, I have a few VLOOKUP formulas that are pulling comments from a previous spreadsheet. The comments have different text colors that I'd like to replicate on this new spreadsheet. As it stands now the VLOOKUP only brings over the comments in plan text. Is there any way to bring over the text color as well? Maybe with conditional formatting? Thanks, Dza Formulas bring back values -- not formatting. If you're using conditional formatting at the source cell, then you could use the same rules in the destination. If you're not using conditional formatting at the source cel...

Remove Final Character from Cell.
Hi All, I am trying to remove the final character from a cell with a find and replace. the cell contents are like the following example. 07APR07A needing to be 07APR07 But other cells in the list are already in the format of 07-Apr-07 07APR07* I have managed to remove the * by using the tide ~ character. So I don't know if there is a similar character to remove the last character only. But am stuck with the last character. Can someone please help. =LEFT(A1,LEN(A1)-1) -- Kind regards, Niek Otten Microsoft MVP - Excel "stuart block" <stuartblock@discussions.microso...

how to know the cell address in point units.
hi, i am using ,expression.AddShape(Type, Left, Top, Width, Height) Left, Top are point units,how to make the shape exactly in the place of an aimed cell. or to say, how to know the cell address in point units. thank you. No need to know the exact coordinates: With Range("J1") ActiveSheet.Shapes.AddShape _ Type:=msoShapeSmileyFace, _ Left:=.Left, _ Top:=.Top, _ Width:=.Width, _ Height:=.Height End With In article <eHmJTYjjEHA.1652@TK2MSFTNGP09.phx.gbl>, "EXCEL�@NEWS&quo...

spontaneous change of formatting
Hello, In the company where I work we are currently experiencing a strange problem. What happens is that randomly and spontaneously, the formatting of the spreadsheets we use gets changed. Say numbers formatted like dates and vice versa for example. This has never happened in the past, and it is something occurring over the last month or so. The spreadsheets have macros however, I checked the code in depth and there is no formatting at all; that is the formatting is just part of the cells properties and that gets changed. We are using Office 2007 and all the files are in .xl...

Selecting a Range of Columns for Variable Rows
I want to do something like this: Select a sheet for row=3 to 17 select cells A:F copy the cells Select A2 on another sheet Paste what I copied. Shift down 1 row next row. I have verything down pretty well except selecting A:F for each row as it comes up. I would appreciate any help you can give me. Thanks. -- BillR It would be helpful if you post the code you have so far. It helps to fill in the gaps in your narrative. "BillR" <BillR@discussions.microsoft.com> wrote in message news:DCB74376-35D4-4426-8DFC-23B2565A9323@microsoft.com... >I want ...

Need additional dimensions in Payroll Posting Accounts Setup
Team, We desperately need the following dimension codes added to the Payroll Posting Accounts Setup: Divsion Location Employee Class We place GP payroll in large government agencies and the current 2 dimensions (department & position) are woefully inadequate. These organizations are complex and have multiple business units and funds for which payroll transactions much be uniquely identified in the general ledger. There are a lot of Microsoft and ePartners people trying to place GP in public sector institutions but until this problem is solved, we are going to be severely limited....

#VALUE in cell but pop up function box show right number
I am using the XIRR funciton in Excel 2003. The cell shows #VALUE but when I click on the function to open the Functions Arguement box, the number is properly calculated in the 'Formula Results'. Any experience this problem? Have a solution? [I have been using Excel for financial valuation for years and I know what the number should be so it is not a simple question of the wrong inputs - like I said, when the Function window is up, the right answer is displayed - I just can't read it in the cell which displays #VALUE.] Hi post yiour exact formula and the values in the re...

Color Categorizing in a Shared Calendar
I am in responsible for scheduling events and appointments in several shared calendars on Outlook 2007. We prefer to color categorize them and I was wondering if there was a way to color categorize an appointment in a shared calendar and have all users see that color category with exact name. For example, we have set up a Conference Room as a separate user in our server so it also has its own email address. Several admin support specialists have access to this Conference Room calendar and we would like to color categorize appointments in this calendar to reflect the different dep...

Formatting percentage signs in Excel
Is it possible to change the size of the percentage sign that Excel inserts in cells when the number in the cell is a percentage? If there are a lot of percentages in a table, it is very difficult to read the numbers because the percentage signs detract from the numbers. It would be good if there were a way to get Excel to automatically insert the percentage sign in a smaller font. Hi, If the cell format is set to Percentage you can't change the font sizes within the cell or have two different font sizes. But, you can change the cell formatting to Text and then change the percent...

Conditional Formatting... #3
I have a table with two columns on a worksheet. The first column holds a value that changes according to an Increment Value. So while sometimes the column might increment by 5, other times it might increment by 10. The column entries sometimes reach values up to 100,000. I want to use conditional formatting to change the fill color (background color) every 100. So if the increment is 5, then the first 20 rows will be gray, and the next 20, white, and so on. If the increment is 10, then each 10 rows, the color changes. My problem is the second column. The formula here depends on...

Can I add a picture to a cell?
Is there a way to add a picture to a particular cell? This way I ca use it for look ups in other sheets. Thanks in advance for any help -- Jua ----------------------------------------------------------------------- Juan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=688 View this thread: http://www.excelforum.com/showthread.php?threadid=26356 Hi not possible as pictures 'float' over the cells -- Regards Frank Kabel Frankfurt, Germany "Juan" <Juan.1d6lzx@excelforum-nospam.com> schrieb im Newsbeitrag news:Juan.1d6lzx@excelforum-nospa...

Referencing using data in a cell?
I have a couple of problems. Firstly, is there a way to make the data i a cell equal to the name of a worksheet. For example, if a worksheet (i the case of the project in question) is called "43" how would I go abou making a cell contain the number 43, or whatever the name of that shee is. Not sure if this can be done, but its worth a try. Secondly how can I refer to a cell on another sheet, but where the nam of that sheet is kept in a cell. For example, in the same case again, want data from a cell on sheet '42' cell 'AE6', so to make a cell i the other sheet equa...

Conditional Format Dates
How do I conditionally format dates that are more than one year old? -- -Andy On Thu, 17 Jan 2008 08:12:06 -0800, Andy12 wrote: > How do I conditionally format dates that are more than one year old? In form design view, select the date control. Click on Format + Conditional Formatting. Set Condition1 to Expression Is In the next dialog box, write: [ControlName]< DateAdd("yyyy",-1,Date()) Change [ControlName] to whatever the actual name of your control is. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail On Thu, 17 Jan 2008 08:12:06 -0800,...