Free Microsoft Excel 2013 Quick Reference

Custom Theme colors - aqua/purple

Hello. I have created a custom theme in Excel 2007 so that I could have
colors that appear more like the old Excel color theme.

Two of my selected colors are Aqua Accent 1 and Sky Blue Accent 2. When I
open my fill-in or text-color drop down and go to choose one of the colors
below these two colors I do not get the color result that is displayed.

For example, under the Aqua Accent 1 my choices a Aqua Accent 1 lighter
80%, Aqua Accent 1 lighter 60%, Aqua Accent 1 lighter 40%, Aqua Accent 1
darker 25%, Aqua Accent 1 darker 50%.

The last two (darker percentages) will enter the same color as what is
displayed. The first three (lighter percentages) do not display the same
color. On the selection they appear as lighter shades of the aqua color, but
when they fill on the sheet, they are different shades of purple.

A similar thing happens with the sky blue color, but only with the first two
choices.

Has anyone seen anything like this before?

Thanks,
Jen


I have created a custom theme. I defined 2 custom color themes and then
saved it all as a custom theme.

When I share the theme template with other users, the theme loads, and the
colors are usable, however, in the Colors section of the Theme area on the
Ribbon, the Custom theme colors don't appear as a selection. Is there a way
to make these show up in other user's applications?

Hello All,

I am applying a chart template with a VB macro (a .crtx file, in other words). However, I'd like it not to have any color scheme associated with it, so that when I change the theme colors at a later stage all of the charts in the document will change their color schemes.

Thanks ever so, any assistance appreciated.

s

I'm creating a column chart with 20 pairs of series. Because there are so
many series (2x20==40), I've done it quickly with VBA. What I haven't figured
out is how to use "theme colors" to set the fill color for each series with
VBA. Ideally each pair would use the same color but with two different shades
(is that even the correct term?). Is there a guide somewhere that explains
how to work with theme colors in this setting? I suppose I'm not necessarily
tied to theme colors, but it would be nice (so users could change the theme,
I suppose). Thanks in advance!

These theme colors in Excel 2007 are horrible! Why in gods green earth would
they do that to excel, and to top it off they don't even make the standard
color palette from previous versions of excel available, how in the heck are
we supposed to use this across a network of shared workbooks when all the
systems aren't running the new version of excel????

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I set up some colors that I liked, saved them as a theme, and then applied
the theme to a workbook template that is now in the start folder. So that
each time I open a new workbook, I don't have to apply the theme, those
colors are already there when I click on the 'fill in.' The strange thing
is, it has distorted the colors below that are shaded from lighter to darker
in the aqua and sky blue columns. If you click on either of these columns
the first four shades give you some variation of purple or blue - not
anything like what the color is that I am clicking on. Has anyone else seen
this?

I am creating a custom theme, but I have run into an issue.
I am able to create a custom Color Theme
I am able to create a custom Fonts Theme
How do I create a Custom Effects Theme??? I can select from a list of "Built
In" Themes, but there seems to be no mention of how to create custom Effects
Themes.

In the Templates Directory, under "Document themes" there are three folders,
Theme Colors, Theme Fonts, and Theme Effects. In each (except effects) there
are XML files that contain the preferences for saved themes. I assume that I
can create custom Themes for Effects, but I can't seem to find out how!

Can someone help me discover how to create my own custom Effects Theme?

Hello,

I would like to add specific shading colors and font colors to my
spreadsheet that I do not see when I select Format -> Cells -> Patterns.

Questions:
1. How do I highlight a cell and give it a custom background color of
Green:3278 , Red: 185?
2. Similar to Question 1, how can I change a font color of numbers to my
custom color?
3. How can I add my new custom color to my pallet so that when I select
Format -> Cells -> Patterns, I'll see my custom color as an option?
4. Similar to question 3, how can I add my custom color as a font color
option?

Thanks in advance for your help.
-Scott

I need to add a lighter brown style color in Excel to color a box, and I dont
have that custom flower looking option that helps you select which color you
want. I only have some "set' colors available to me. Is there any way to
add or make that box appear for a different color selection?

"more fill colors" used to show up for me in excel when i filled in colors on
a worksheet. i would then be able to customize the fill color. however, i
bought a new compture with windows xp loaded, and now that option does not
appear in my excel (but does appear in word). how do it get it in excel?

I would like to use a custom color in cells in Excel, but I can't seem to
find how I change it to one not pre-loaded into the program.

After submitting a request at this URL:
http://www.microsoft.com/office/comm...ype=suggestion
I was given the option to post to a newsgroup.
My suggestion is the subject of this post.
I use color regularly to make spreadsheets more readable and easier to
navigate. Excel's color palette options are extremely limited in flexibility.
At very least I'd like to see the option to create and save custom palettes
and load them at will into a worksheet without having to resort to clumsy 3rd
party utilities.
Anyone else?

KZ

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I have been customizing my color palette (tools/options/colors) in a file and saving that file, but for some reason the palette switches back after some time to the default palette (not sure what event made it switch back, I was never warned or prompted for anything).

Any clue? How can I keep my custom palette? I would love to make it default for ANY XL documents,

thx,
jm

When I open a new worksheet it is purple. The fill color bucket it defaulted to no fill. I select the entire worksheet and click on the 'no fill' and get a normal white background. If I delete anything on the spreadsheet, where the items were deleted the background is again purple. I have to select and again click on 'no fill'. I am constantly fighting this creaping purple. Just started about a week ago. No idea what I did to cause this? Anyone have any ideas?

Is it possible to customize fill colors of a spreadsheet? The spreadsheet is to be posted on the web and the available colors are limited and visually jarring. Is there any way to use the web color palette instead of what comes with the Excel program?

"more fill colors" used to show up for me in excel when i filled in colors on
a worksheet. i would then be able to customize the fill color. however, i
bought a new compture with windows xp loaded, and now that option does not
appear in my excel (but does appear in word). how do it get it in excel?

I need to add a lighter brown style color in Excel to color a box, and I dont
have that custom flower looking option that helps you select which color you
want. I only have some "set' colors available to me. Is there any way to
add or make that box appear for a different color selection?

I swear that I used to be able to customize my fill color in Excel a long long time ago. Now I only see the preset colors. I really want to customize my colors, is there a way to do that?

Thanks,

Hi everybody,

I'm trying to do a report with Word 2007.
For each chapter I would like to use a different theme color.
However can't figure out how to do that with Word 2007. Is it even possible ?

The style/theme I'm using is Modern , and it seems impossible to modify the color of the headlines manually so I really need to find a solution to my problem.

I currently just started using windows 7 ultimate and ran into a problem! When I go into my display properties to change my theme, from the windows 7 theme that windows aero works with, to a custom theme (where all my photos ran in a slide-show) as soon as I restart my computer, the Aero (the transparency) goes away. so i used the windows search top try and find out how to turn it back on. It told me to go into the display properties where you would normally change the color of your task bar. Instead of bringing me to that window that it showed before it brought me Straight to the advanced appearance section where you can customize your Desktop, Icons, 3D Objects, menu, scroll bar, and window's color, font, and size. Now being tech Savy (A+,Net+) I was frustrated that i could not fix this problem.

Hi there

I am trying to find out if there is a way to change the theme colours in Excel 2008 for Mac.

I have searched google and there appears to be an option at the base of the theme colours on Excel 2007 but I can't seem to find it in 2008.

Ideally I would like to create a custom set of colours and fonts and then use these to save a new theme.

Any help would be really appreciated.

Thanks in advance.

Tom

I am coloring every other row of a worksheet to have a 'green bar paper' effect. The color desired for the screen does not produce a dark enough gray shade on print jobs. I have found some useful color wheel tools on the web to darken the color without changing color shade but we are changing the customers default color scheme to get this darker print shade.

Is there a way in VBA code to set a regular screen color property and a separate print color property for a range? How does Excel decide what level of gray shading to use for colors anyway? For two close but different brightness colors it appeared to generate the same gray shade (but my eyes aren't the greatest).

Thanks,
Ken

Something I've decided to just start adding to my VBA apps. I put this in it's own module called: "Mod_ColorEnum"

The commented "duplicates" have the same RGB value as another ColorIndex, therefore the same name, so I just comment them out to avoid the duplication error but leave them there so no one (including myself) will think I've forgotten any.


	VB:
	
 
 
 'ColorIndex Enumeration
Public Enum Color 
    Aqua = 42 
    Black = 1 
    Blue = 5 
    BlueGray = 47 
    BrightGreen = 4 
    Brown = 53 
    Cream = 19 
    DarkBlue = 11 
    DarkGreen = 51 
    DarkPurple = 21 
    DarkRed = 9 
    DarkTeal = 49 
    DarkYellow = 12 
    Gold = 44 
    Gray25 = 15 
    Gray40 = 48 
    Gray50 = 16 
    Gray80 = 56 
    Green = 10 
    Indigo = 55 
    Lavender = 39 
    LightBlue = 41 
    LightGreen = 35 
    LightLavender = 24 
    LightOrange = 45 
    LightTurquoise = 20 
    LightYellow = 36 
    Lime = 43 
    NavyBlue = 23 
    OliveGreen = 52 
    Orange = 46 
    PaleBlue = 37 
    Pink = 7 
    Plum = 18 
    PowderBlue = 17 
    Red = 3 
    Rose = 38 
    Salmon = 22 
    SeaGreen = 50 
    SkyBlue = 33 
    Tan = 40 
    Teal = 14 
    Turquoise = 8 
    Violet = 13 
    White = 2 
    Yellow = 6 
     '    Blue = 32 'duplicate of 5
     '    DarkBlue = 25 'duplicate of 11
     '    DarkRed = 30 'duplicate of 9
     '    LightTurquoise = 34 'duplicate of 20
     '    Pink = 26 'duplicate of 7
     '    Plum = 54 'duplicate of 18
     '    Teal = 31 'duplicate of 14
     '    Turquoise = 28 'duplicate of 8
     '    Violet = 29 'duplicate of 13
     '    Yellow = 27 'duplicate of 6
End Enum 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

The color enumeration is handy for use with any object that has a ColorIndex or SchemeColor property; just add 7 to ColorIndex to convert to SchemeColor. Enumerations are nice because all the color choices appear as a dropdown list in the VBE after you type "Color.".


	VB:
	
 test() 
     
    Range("A1").Interior.ColorIndex = Color.Orange 
     
    With ActiveSheet.Shapes.AddShape(msoShape5pointStar, 200, 200, 50, 50) 
        .Name = "YellowStar" & ActiveSheet.Shapes.Count 
        .Fill.ForeColor.SchemeColor = Color.Yellow + 7 
    End With 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Also worth noting that Enum only works in XL2000 or later.

Ok, here we go again.

I need some help, probably using vba, but a function would work too. Given two criteria (Letter Grade(B+,C,C-,etc..) and Cell Color), I need to count all that match the criteria... To best understand, see the attached document, I need to count in the range M:AZ, and return it to the "Report". The position of the report varies, so code that can be universally used would be good.

Example:

Cell Values:
BD+E (cell color is purple)
BDE (cell color is purple)
ACD (cell color is orange)
D-EF (cell color is yellow)

Results:
Purple "B" - 2
Purple "D" - 1
Purple "D+" - 1
Yellow "E" - 1
Orange "D" - 1
etc...

I'm really struggling on this, so any help is greatly appreciated... Thanks in advance!
ColorCounterSample.xls

I am trying to create some VBA code that allows me to change the color on an AREA graph when the value is equal to a certain text. Below is an example.
So instead of using Excel theme colors, I want to set a certain color to use. So if the graph has AAA it gives a specific RGB color that I set, BBB, CCC, etc. I have code that works for Pie Graphs and Bar Charts, just not AREA graphs. Any help would be appreciated. Attached is my code for the Pie/Bar. Maybe it just needs a little tweak.
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 AAA 383.9 291.5 706.1 855.2 627.2 632.3 743.3 774.0 775.7 771.7 BBB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 100.0 CCC 0.0 0.0 0.0 80.7 81.4 53.0 23.0 8.0 8.0 8.0 DDD 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 112.5 170.0
'==================================================
' Program: ColorChart
' Description: Changes the color of Columns/Pie Slices based on cells in range
' with competitors
' Called by: Toolbar button "Color Chart"
' Arguments:
' StartCell — allows user to select the upper left cell of the range
' (vertical range)
' i — counter for loop to go through SeriesCollection
' FirstCol — determines column of StartCell
' FirstRow — determines row of StartCell
' LastCol — determines last column from StartCell
' LastRow — determines last row from StartCell
'==================================================
Sub ColorChart()
Dim i As Long
Dim myComp As String
Dim FirstCol As Integer
Dim LastRow As Integer
Dim StartCell As Range
Dim FirstRow As Integer
Dim ChtObjCount As Integer
ChtObjCount = ActiveSheet.ChartObjects.Count
On Error Goto Canceled
If ActiveChart Is Nothing Then
InputBox "Select Chart"
Exit Sub
End If
Set StartCell = Application.InputBox(prompt:="Select Start Cell", Type:=8)
FirstRow = StartCell.Row
FirstCol = StartCell.Column
LastRow = StartCell.End(xlDown).Row

With ActiveChart
With ActiveChart.SeriesCollection(1)

For i = 1 To LastRow - 3
myComp = ActiveSheet.Cells(FirstRow - 1 + i, FirstCol).Value
Select Case myComp
Case "AAA"
.Points(i).Interior.Color = RGB(51, 102, 255)
Case "BBB"
.Points(i).Interior.Color = RGB(50, 100, 255)
Case "CCC"
.Points(i).Interior.Color = RGB(51, 51, 153)
Case "DDD"
.Points(i).Interior.Color = RGB(255, 153, 0)
Case "EEE"
.Points(i).Interior.Color = RGB(243, 100, 0)
Case "FFF"
.Points(i).Interior.Color = RGB(204, 153, 255)
Case "GGG"
.Points(i).Interior.Color = RGB(0, 204, 255)
Case "HHH"
.Points(i).Interior.Color = RGB(255, 219, 0)
Case "III"
.Points(i).Interior.Color = RGB(255, 219, 0)
Case "JJJ"
.Points(i).Interior.Color = RGB(255, 0, 255)
Case Else
.Points(i).Interior.Color = RGB(128, 128, 128)
End Select
Next i
End With
End With
Canceled:
End Sub