1
vote
1answer
14 views

Excel Conditional Formatting Colour Scales highlight group of cells when another cell is a certain value

So I have a document that has 2 drop downs with the first acting as a currency selection and the other acting as a discount selection (0% - 50%). Basically whenever I select from the dropdowns the ...
-1
votes
0answers
17 views

comparing two excel documents to match row color of first document

say i have two excell documents, .... one was sorted manually the day before, and then color coated in certian colors based on certian criteria, and the next day a different report comes out that ...
0
votes
0answers
17 views

New theme colors, Excel 2010

Consider I want to make a new theme for my workbook. First (for the colors) I go through Page Layout > Themes group > Colors > New custom colors. In this dialog box There are 4 text/backgrounds, 6 ...
0
votes
0answers
8 views

Use custom undefined color in Excel 2003

I want to change background of the cell. I click the icon in the toolbar to do that, but only pallete of predefined colors is offered: But I want my own, custom color which is not present in the ...
0
votes
1answer
82 views

Coloring separate rows based on matching of data in key cell

i have a excel file as i want change the sheet that after sort on key column(MasterID), any rows same as key column change color to similar. for example
2
votes
1answer
311 views

Use Excel Color Scale Formatting with Text

I use Excel sheets to track the status of tasks through a set of discrete statuses. I'd like to be able to format these automatically, with the start being red, the end being green and progressing ...
0
votes
1answer
393 views

Excel - Change font color of a row on double click

I'm trying to change the font color of the row in which the cell is located when I double click it from black to grey, and the opposite when it's already grey. Here is the code I'm trying: Private ...
1
vote
1answer
561 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 ...
4
votes
2answers
5k 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
453 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
92 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
904 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
218 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
1answer
11k 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
120 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
1k 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
1k 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
13k 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 ...