Coloring Percentage Values
Oct 7, 2008
I need to coloring percentage values in excel 2000. What I would like to do is have percentages greater than zero shown in green, while negative values are red, and zero values are black. I currently have the custom formatting so negative values are red and all others are black, but I cant' seem to find a way to change it so greater than zero numbers are green and zeros are black. All I can do is chang positive and zero at the same time. Here is what I currently have:
View 3 Replies
ADVERTISEMENT
Jan 16, 2010
I'm new here and not really that familiar with excel functions and programming so please forgive me if this is not the right place for my thread
I am wondering how (if possible) I can make this little scenario work:
Lets say I have
cell (A1) with the value 2
cell (B1) with the value 3
Now somewhere else I wish to color some cell to create a 2 by 3 "block".
So coloring 2 cells horizontically (the value of (A1) and 3 cells Vertically (value of (B1)
View 12 Replies
View Related
Apr 15, 2014
I have two columns, A and B (I technically have a lot more in my sheet but to make it simple just focus on these two columns). The two columns are Company Name and then Company Color. I want to write a macro that based on what color is in Company Code (B1:B500) to highlight Company Name (Column A) based on those values in column B.
Below is an example:
I would want GE to be Red for example.
Company Name
Company Color
Google
White
GE
[Code]...
View 3 Replies
View Related
Sep 15, 2009
I am trying to create a formula that can work out the % difference between two values. The formula I am using is:
=(B1-A1)/ABS(A1)
So, where
A1=1, B1=2, = 100%
A1=-1, B1=2, = 300%
This seems to work perfectly, apart from where there are zero numbers involved. The answers I want to have are as follows:
A1=0, B1=0, = 0%
A1=0, B1=-1, = -100%
A1=0, B1=1, = 100%
A1=-1, B1=0, = 100%
A1=1, B1=0, = -100%
View 3 Replies
View Related
Jun 19, 2009
I am trying to exclude a certain value from an array of numbers to get a percentage. I have data that populates on its own and in the same columns regularly. The data contains a country name in column A, a year in columnB and a value in column C. I am trying to exclude the value for the U.S. in the totals so that I can get a percentage of values outside of the U.S.
So that the sum of all of the rows less the value corresponding to the U.S., divided by the sum of all of the values.
The problem is that the location of the U.S. value and U.S. designation varies with different inputs (this cannot be helped), so the formula must be able to follow it.
I have been able to do this but not without a lot of extra cells and rows, and I would like to have a single formula.
View 5 Replies
View Related
Feb 4, 2008
I'm trying to make my spreadsheet display over 100% while calculating a long column of entries. Each entry is showing percentage cost per hour of a benchmark of $65.00 per hour. When an entry for example is $51.10 the percentage displays 0.79%, but if the entry is for example $73.89 then the displayed value is 1.14%.
How do I make this display the percentage over the benchmark of 65 as 110, 115 or whatever it calculates out?
View 9 Replies
View Related
Jan 16, 2008
How do I change numerous numbers in several different columns by a constant amount? example reduce each number in each of these columns by 50%.
View 9 Replies
View Related
Dec 2, 2013
I'm designing a spreadsheet currently. I want to input a number into cell A1 - for example 13. Now the number 13 has a percentage value of 67.3%. When I enter the value into A1 I want excel to automatically fill cell A5 with the percentage value of 67.3%.
I need to have the numbers from 1-20 all with varying percentage values.
1 = 100%
2 = 97.8%
3 = 94.3% etc..
So essentially I would like to enter 13 into cell A1 and for cell A5 to automatically fill in the value of 67.3%, if I was to change the value in A1 to 10 it would also automatically change the percentage from 67.3% to 74.7%..
View 10 Replies
View Related
Jan 26, 2014
Using conditional formatting to make all the cells that contain numbers and are formatted to percentage format make display in red color? let's say I want to set this conditional formatting rule initially after just opening the excel book and afterwards when I type in values/text etc. into the cells I want the cells where I have input numbers and chose the percentage format to come out in red color? and all the rest stay in black color?
View 6 Replies
View Related
Jun 9, 2009
What I would like to do is to delete the rows in the attached Excel file highlighted in yellow (whole numbers) and to keep the rows with percentage values. Ideally I would like to have only the rows with the string "Group:" remaining along with the rows that have percentage values in them.
What I'm going to be doing is then transferring these groupings of data to another excel sheet in order to create a time series of performance by "team leads". If anybody would be willing to help me out with the first part of this I would really appreciate it. I have some idea of how to go about it using conditional logic, but I'm just not comfortable enough in VBA to do this efficiently. It would probably take me hours just to get a simple version working....
View 6 Replies
View Related
Feb 13, 2009
I have a little table:
Columns A:B (separated by commas)
Row 1- Year One, 20
Row 2- Year One, 20
Row 3- Year One, 10
Row 4- Year One, 30
Row 5- Year One, 20
Row 6- Year One, 20
Row 7- Year Two, 10
Row 8- Year Two, 20
Row 9- Year Two, 20
Row 10- Year Two, 10
Row 11- Year Two, 20
Row 12- Year Two, 40
In the adjacent cells in columns C (C1:C12) I need a formula that would turn the value into a percentage of the total of the values for that year (e.g. in C1: 20 is 16.7% of 120, so the value displayed would be 16.7% (or 0.167)).
View 3 Replies
View Related
Jan 16, 2014
I have a list of group ID codes, which contain 1 or more product codes within them.
Some product codes contain an "alternative" value (the actual value is irrelevant) and others do not. See example below
Group ID
Product Code
Alternative
56381
240027
160380
[Code] .....
Ultimately what I need to achieve is a percentage of how many product codes, within each group ID, contain an alternative.
So for the example above, group ID 56381 would have 50% codes with alternatives.
By counting the occurrences of a group ID and whether 1 particular code has an alternative I have calculated individual percentages against the size of the group e.g. product code 240027 (given a value of 1) divided by the total number of codes in the group (4), returns 0.25. Obviously doing this across the whole group would give my result (0.5 or 50%)
However some groups contain over 100 codes and the spreadsheet is 40K rows!
View 5 Replies
View Related
May 23, 2013
I am trying to add 2 cell values together then show the total as a % of a value in a 3rd cell, however I also need it to allow for 0 values in the chosen cells without displaying an error message or it messes up the average formula elsewhere on the sheet?
View 2 Replies
View Related
Jan 8, 2009
Good afternoon Gentlemen, I have a column of data, with a varying number of percentage values that add up to 100%, separated by "NA", i.e.
33%
33%
33%
NA
25%
25%
25%
25%
NA
100%
NA
20%
20%
20%
20%
20%
NA
Now... when I change one of the values I would like the others to even up, i.e. in the last example if I change a 20% to 50% I would like the others to change to 10%... any ideas?
View 11 Replies
View Related
Jan 27, 2010
How would I write a formula that takes cell values from six worksheets and adds them up as a percentage (quarterly updates)? I realize this is wrong, but here's what I'd tried (for three sheets).
=+SUM(IF(EVH!F7="Y",25,0)+IF(FUN!F7="Y",25,0)+IF(HES!F7="Y",25,0))/3
View 9 Replies
View Related
Aug 24, 2014
Data is;
83300 - hypothetical number of times I have fired my gun at target.
43209 - hypothetical number of times I have scored bullseye.
So, my bullseye percentage = 43209/83300, or ~51.87%.
Need formula to determine how many more consecutive bullseyes I need to shoot, in order to achieve 70% ratio.
Since each shot from now on will be a bullseye, both values (hits & shots) will increment together.
View 5 Replies
View Related
Dec 18, 2013
I have a Pivot Table with fields for months and weeks. I also have a "Show Values as % Difference Field" that shows monthly or weekly % change. When I collapse the fields so that it goes from weekly to monthly (or vice versa), I have to manually change each Show Values As % Difference column. Is there a way to do this automatically or quickly?
View 1 Replies
View Related
Apr 5, 2014
I have a daily report that gives a percentage based on what is typed into the "Supplier" and "Total Sales" columns but I'm having trouble writing the following formulas since my excel knowledge is relatively low.
1. Where a cell in the "Supplier" column says anything but "Den", "Burrowed" or "Studio Nyx" I need the "60%" and "40%" columns filled with the relevant formula (=B11*60% for example) and the "100%" column blank.
2. Additionally, if the cell contains "Den", "Burrowed" or "Studio Nyx" I need the "100%" column filled and the "60%" and "40%" blank.
View 6 Replies
View Related
Oct 25, 2005
I have a single column of numerical values that may repeat many times within
the column.
I require a flexible Formula:
Use an Input Cell for the specified and changeable Percentage(s) %.
Column may be filtered – so only take into account Visible Filtered Cells.
The Formula will calculate and Return the numerical range of values that fall
between the specified percentage % (using the Input Cell) e.g.; 70%.
The Formula should Return two numeric values: a Start Value and an End Value
– NOT necessarily the minimum and maximum per se BUT the MIN and MAX of the
values that appear 70% of the time in the column; therefore, taking into
account Repeat / Duplicate values.
The calculated Results: the two numeric values will be returned to separate
cells on a new Sheet.
View 9 Replies
View Related
Jan 16, 2007
I had this question earlier and I dont know if it just isnt a regularly answered section so I though i would ask it here.....better yet I will just link to the other page so you can see whats up. Hopefully i will get a few more hits on it in this thread.
http://www.excelforum.com/excel-charting/586210-how-to-color-a-range-of-cells-if-one-has-data-entered.html
View 14 Replies
View Related
Jan 22, 2007
trying to do is when the input in a Cell becomes zero then I want that the cell becomes for example Red.
I'm not using macro's just formulas.
View 11 Replies
View Related
Jan 22, 2010
Is it possible to create UDF for Interior color of cell?
For instance, =Color(A1;3)
3 is the index of red color.
View 12 Replies
View Related
Nov 9, 2006
Is it possible to set a formula or something up so that if a row contains certain information, then the row will turn a certain color? For instance, if cell B2 contain the number "3" and cell B5 contains the number "5", then row B will turn yellow. Then if cell C2 contains the number "4" and cell C5 contains the number "7", row C will turn blue. This is just an example. In this example, I'd like a formula all the way down column's 2 and 5, but only the rows would change color (not columns) according to their information.
View 9 Replies
View Related
Aug 25, 2009
I have got a Pivot table with makes and their sales in 2008 and 2009 like this
2008 2009
BMW 100 90
Audi 80 80
Mercedes 200 150
Fiat 80 120
Honda 100 110
Peugeot 70 120
(unfortunatley the formatting is deleted when posting).
I have created a stack column chart.
In that chart I want certain makes to have certain colors like BMW = blue, Audi = yellow, Mercedes = black, Fiat = green, Honda = red and Peugeot = purple
When I update the Pivot with a new month and a make changes position the colors go wrong.
I would like to create a script that fixes the makers to their colors, so that after an update I can just run the script and am done .
Unfortunately I do not really know how to work with VBA (I can just steal macros and modify them a bit to my needs or use the recorder).
View 9 Replies
View Related
Feb 4, 2007
I have an input in a cell, let's say: 8:50.
Is it possible to change the color of that cell in red if the text changes in
9:00 for example.
View 13 Replies
View Related
May 10, 2009
Cells in column B need to be colored red if they are equal to 50% of the cells in column C in the same row, or if the cell in column C in the same row is 100.
View 5 Replies
View Related
Nov 13, 2011
With a range of cells (a1:ao41) I want to color several cells depending on the value of that particular cell and another color when that particular and a corresponding cell have both the same value. It's some sort of sociogram The first row and column both contains names of students. Let say the students have to choose the three most populair ones to work with and the three most unpopulair ones. Positive ones get the color blue, negative ones get the color yellow. That's easy to do with conditional formatting. But now comes the tricky part. If for instance Student 3 chooses Student 7 and Student 7 chooses Student 3 the color of both cells have to be green if both positive and red if both negative. That's also do-able with conditional formatting, but it most be much easier to do with VBA. I just don't know how .
View 5 Replies
View Related
Feb 8, 2008
I have reviewed many a thread today looking up how to color in cells c11 through c20 without conditional formating.
if these cells have a time less than 01:00 then they turn green
if these cells have a time greater than 01:00 then they turn red
if the time is equal to 01:00 then they turn white.
View 9 Replies
View Related
Oct 2, 2008
I have this code that colors the lines in my Line Chart
Sub ColorLines()
Application.ScreenUpdating = False
Set chrt = ActiveChart
'Here you want to put your own graph
vals = chrt.SeriesCollection(1).Values
'These are the values to determine later whether the line moves up or down. In this example, I just colored 1 seriescollection (= one line in your line graph), with an extra loop you'd do all lines.
It is very simple: When the lines goes up they turn black. When they go down they turn red.
The code work, but only if all cell in the series is filled. If one cells is blank the code error. I'm using #NA() in all cells that are blank, so the chart skip that cell and continue from the next cell's value.
View 9 Replies
View Related
Apr 20, 2009
i hav sheet containing list of employee number, think it is a labour camp, each room have four labours, each have a unique code. I made sketch in excel and enter all labour number in each cell, border them look look like a room, i have 120 rooms like that.
Now the problem :D, i hae different national labors
I have seperate list having their national according to their employee code.
Now i wanna color thier cell according to their national
I am searching a code and formula for last 45 days...
View 9 Replies
View Related
