Tagged Questions
0
votes
1answer
15 views
How to invert the coloring scheme in “Color Scale” quick analysis?
I have a table comprised of % values where a higher one is something bad whereas a lower one is good.
Using the quick analysis option "Color Scale" I get at a glance which is better or worse but the ...
0
votes
1answer
39 views
Add custom colors in Excel 2010
I'm working on a spreadsheet which was created in an earlier version of Excel (2003 I think), and it makes extensive use of color-coding for organization. Unfortunately, it was built using the ...
2
votes
1answer
138 views
Can I provide RGB hex strings in an Excel worksheet for pie chart colors without using code?
Like user1813558 in his question "Change the pie chart colors" I would like to choose the colors that Excel uses for a pie chart (indeed for any chart) as I need them to be consistent with other data ...
0
votes
1answer
54 views
Can I get the properties of the color of a Microsoft Excel cell in numbers/text?
I want to count the yellow, red and white (no color) cells in a column (range) within a Microsoft Excell sheet.
The colors are equal (i.e. only one RGB value of yellow is used, not light/dark yellow ...
2
votes
1answer
281 views
Excel 2010 shows different cell fill colors depending on Windows Appearance Settings
I just noticed something very strange. I created an Excel workbook in Excel 2010 (Windows 7) and manually formatted alternate rows with slightly different colors. When my colleague opened the ...
0
votes
1answer
109 views
Create a full excel color palette from 3 colors
My company has a color scheme consisting of 3 colors.
In RGB:
Blue: 25 176 230
Green: 180 213 83
Gray: 129 130 133
(Please don't judge the choice of colors, they are not my choice!)
I need to ...
1
vote
0answers
3k views
Unable to change Excel cell font or shading colors.
6/15/2012
I'm having the same problem as a previous user's query (linked below) wherein I can't change the font or cell shading color on an Excel spreadsheet. I've confirmed that the cell/spreadsheet ...
1
vote
1answer
102 views
Is there a formula that I can use so that I can get a cell on Sheet 1 to have exactly the same formatting as a cell on Sheet 2?
I am using an excel spreadsheet to record skill competencies of staff. Sheet 1 will act as a "master" sheet reflecting the skill competencies of all staff (ie different employee in each column) and ...
1
vote
1answer
927 views
Conditional Formatting of a Cell Based on Color Value in that Cell in Excel
Is is possible to format a cell based on one component of the RGB value inside of it. For example, let's say I have 3 cells - A1, A2, A3. In A1, I want the cell color to be the shade of red anywhere ...
2
votes
1answer
699 views
How to retain background colors when pasting between documents in Excel
I have a script that programatically generates excel spreadsheets - cleaning up ugly reports that are given to us from another organisation. For interests sake; I'm using PHPExcel to generate the ...
3
votes
1answer
8k views
In excel, cannot figure out why background color for a cell will not change?
Ok, so I inherited an excel workbook full of excel forms to modify. I am not the original author of the form. I cannot for the life of me figure out why it wont let me change the background color of ...
