I want 2 cells that are not next to each other and that contain times of day to highlight only if the times overlap, I cant figure out how to make the conditional formatting do this...
View 2 Replies
need to understand the easiest way of highlighting the highest and lowest number in a range of cells several times in the same column.
As I said the cell range will be in the same column. So highlight the highest number green and lowest number red in cells a3 to a9 and then repeat the same process again in cells a11 to a17 and so on.the cell references are an example.
So I have several separate sets of numbers in the same column.
Is it possible to highlight the three lowest cells with different colors within a given range. Example: I have a range of value( times from a 100 meter dash race)from cell B4 to cell B14, how can I highlight the fastest time in red, the second fastest in blue and third in yellow.
View 2 Replies View RelatedI have two columns.
Column A is a list of Sales Reps over 100 of them with different names.
Column B is a list of Products attached to the Sales Rep. For each Sales Rep, it can vary from 5 - 10 different products
I want to find out whether any products are assigned to the same Sales Rep. How do I do so?
Here is my data
Range A1:L8
1234567891011Overlap111122275%22275%22250%22225%2220%2220%
I am trying to figure out a formula in L3 which is the calculation of overlap of region1 and region2. The top row is the number of days. What formula can I use to calculate the percent overlap? The numbers in column L show the expected result.
(Using XL 07)
I would like to know is it possible to overlap the data & view it as Chart format.
View 1 Replies View Relatedtrying to update pie charts via vba. This is working fine, but I have a problem with the data labels. The number of categories can change each time the macro / data is run. This is as it will be for different customers that takle different products.
When the data labels are remapped, those with a small percentage end up placed untop of one another. I have already played with grouping these small percentage together into an 'Other' Category which works fine, but I know I will be asked to split this out.
Is it possible to add a condition that states 'DATA LABELS MUST NOT OVERLAP' - or is there some way of working around this to the same effect...
im trying to plot two series of data on the same chart, as a bar chart, say for e.g:
how many people eat oranges on any given day in a month on the primary y axis and how oranges 1 person eats in day on the secondary y axis..... thats all fine but when i add the series as a bar chart is overlaps the bars.... each series is on the correct axis i just dont want them one behind the other, is there a way i can have them next to each other. edit*based upon the comment below i have attached the image*edit
I am trying to get two shapes to butt up to each other. Unfortunately the shapes either leave a small gap or a slight overlay. I have tried using Ctrl + arrow key to move in small increments, but that didn't work. I have also tried adjusting the width of the rows, but the rows jump backwards or forwards to a number instead of staying with the number I entered. I want to create a seamless shape out of many different shapes.
View 6 Replies View RelatedI am trying to determine the total hours of downtime accumulated when there are 2 or more machines down during the same time period. To do this, I need to be able to determine if at any point there are 2 or more pieces of equipment down at the same time, and if this is true, how many hours were overlapped. The attached spreadsheet shows how the data is presented.
View 7 Replies View RelatedI have a Column Graph that will be changing automatically as the data is changed. My problem is that for one set of data the chart looks fine....but if a number becomes negative the bar will overlap with the data labels at the bottom and cause it to be unreadable. I am not able to resize the x axis area or move the labels down any. Is there anyway to make the labels adjust automatically?
View 3 Replies View RelatedI am trying to get two cells to be used to adjust other cells on the same sheet repeated times.
In a inventory sheet I have 5 columns as such , A1 previous balance, B1 Qty received, C1 qty on hand, D1 last cost, E1 current avg cost What I want, is to be able to enter my weekly received items in the B1 Qty received and the new cost in D1 Last cost cells and have them calculate my current average E1 and update my qty on hand C1 total. This in itself is not the biggest challenge. I was asking if there is a way that after the E1 current average cost and C1 qty on hand are updated by that formula, that the next time I enter a new B1 qty received and new cost in D1 Last cost cell they will update again basically without changing the earlier calculations achieved .
Example: Today I have item X with a A1 previous balance of 10 , with a D1 last cost of $1, and E1 current avg cost $1
I want to receive B1 10 more today at $.50 D1 last cost, which ideally would end up showing
A1 previous 10 (or 20 if adding) , C1 Qty on hand 20, D1 Last cost .5, E1 current avg $.75
Next week I want to receive B1 10 more at $.25 D1 last cost , which then would update showing
A1 previous balance 10 (or 30 if adding), Qty on hand 30, Last cost $.25 and E1 current avg $.58
1. I want to highlight cells on a form so that a user knows which cells to fill out.
2. When they print the form I do not want the cell shading to print.
I am trying to write a macro which highlights all the cells with any reference to other cell. The macro should highlight a cell with formula like = 3 * A25 but not highlight a cell with following formula. = 3 * 0.4535566. 'Hasformula' property is not useful here as it can't distinguish between above examples.
View 3 Replies View RelatedI have a lottery pool in sheet 1 in which i have the names of the people and their number picks. In sheet 2 i have the lottery results.
All i want is to be able to highlite(adding a backround color in the cell) to the matching numbers in sheet 1.
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.
I am trying to add a ROW of times. Each cell of times is using the 00":"00 format so I don't have to type a colon between the hours:minutes.
I'm not sure of what the formula should be for the Total Hours box.
For example, if I were to type 13:45 in the start time & 14:00 in the end time, I am getting a result of 0:55 which is incorrect
Another example if I leave the first 2 start/end boxes empty(blank) and then type 15:30 Start & 17:00 in the second set of Start/end boxes, I get a Total Hours of 1:70 which is also incorrect.
The formula I have in the Total Hours box is =SUM(B12-A12)+(D12-C12) which is know is incorrect.
What is the correct formula which will give me a Total Hours which adds a row of times correctly?
StartEndStartEndTotal Hours
Is it possible to create an individual variable time clock that is only useable by a specific workbook?
I have set up a calendar which has all days of the week in column 1, with start times in column 2 and end times in column 3. These times are adjustable on a daily basis.
Is it possible to create a macro that reads through the sheet and tells the workbook to disregard the system clock and use only the start and end times for each date stipulated in the table.
ie 7/9/06 has a start time of 6am and a finish of 6pm, not 0000 and 2400 as it would with the system clock?
I am running a macro to make some changes to certain cells in a spreadsheet (formula changes)
Is there a code I can include within the macro so that all cells that change are also highlighted in yellow?
I have data in cells that are separated by pipe characters. What I need to do is to highlight the cells that are not the same. For instance, if a cell contains xxx|xxx then the cell is not highlighted but if a cell contains mmm|mmm|xx then the cell needs to be highlighted.
Sheet1 Â A1xxx|xxx2rrr|rrr|rrr3ttt|ppp4OO|OO|OOO5zz|zz|zz|tz6aaaaa|aaaaa7jj|jj|jj|jj|jj|jj8yy|yy9ww|tf|mz
I have a workbook and trying to copy all the way down the workbook using F4 blanks etc. When I highlight the column I want to fill in its not highlighting all the cells.
View 9 Replies View RelatedI have a spreadsheet that I need a m acro for, that will look at cell C13, if it is a 0 (zero) then hightlight cell C1 yellow. And so on, if C14 is zero, highlight C2..
Also look at the cells below,
cell D13, if it is a 0 (zero) then hightlight cell D1 yellow. And so on, if D14 is zero, highlight D2..
Attached is a workbook with some sample data. All cells in column A have a unique value that should be applied towards all values in column B corresponding to that cell in column A. For instance, A1 should apply towards all data in B1.
What I initially did is took all the values in column B and put them into a separate worksheet (this information is on sheet 2 of attached workbook) and used the text to columns to separate them into individual cells, but still horizontally.
What I need is for the macro to take all data in one row, copy paste special values transpose (to vertical) into column B of sheet 3. THEN (here's where I can't seem to get it...) I need that corresponding unique value from sheet 1, column A, to be copied and pasted into sheet 3 and autofilled down for the number of values it corresponds with.
ok is there a way to have excel fill a certain number of cells with specific data specified X times? For example, the end result would look something like the pic below. The column on the right would change according to the numbers specified in the yellow column.
View 9 Replies View RelatedI have an excel sheet, Data's range is B2:B5.
The data is listed as follows: Tom, Pete, Steve, Lisa.
I need a VB code to copy and paste the names (range) to J2:J17. By having the names pasted four times each.
The result would look like this:
Tom
Tom
Tom
Tom
Pete
Pete
Pete
Pete
Etc.
In my workbook I have about 20 sheets (less in the attached sample), and on most sheets I’d like to query data for each day and find an average value based on the time and then copy that result into another sheet. I’m not sure if I’ll need 2 macro’s for this or if one can be used.
Here’s a quick description:
Assuming that I am currently in the sheet I want to run the macro, then I will either input “1:45” or “0:45” into a popup box, or I could always simply input the 1:45 or 0:45 in the code itself. I’m flexible
1:45:
If I input 1:45, then I’d like the macro to find the first 1:45 in Column B and the value in the same row in Column F will be used in the calculation. Once 1:45 is located, then the macro moves up to find 22:45 in Column B and the value in the same row in Column F will be used in the calculation.....
I'm after a formula (or similar) that if cell H1 has no data in then cells A1:G1 must be highlighted in a colour, considering A1:G1 has data in. And then when data is input into cell H1 then the highlight disappears. is this possible?
View 8 Replies View RelatedI am trying to create a special workbook for my asphalt project. After inputting all of the day's truck information, I want to add up the total tons and then for the program to highlight which truck puts the total tonnage at or slightly above 500 tons. I'm not sure if "isolating is the right term to describe what I wish to do or not, but my whole workbook will be based off of similar actions like what I'm requesting. Here is a portion of my sheet:
Truck #Tonnage
1 21.93
2 22.84
3 23.21
4 24.89
5 24.8
6 25.01
7 24.88
8 24.44
9 23.14
10 24.53
11 22.03
12 22.61
13 24.9
14 24.69
15 24.85
16 24.81
17 24.82
18 22.55
19 22.18
20 24.52
21 22.49
22 24.81
And so on.....
I have a sheet that I have item numbers in a column that i want to highlight and change color when they are not the same. I want the colors to be unique to each number. I am currently using conditional formatting (Format cells based on their values (3-color scale)). I works alright but not perfect.
condition formatting.PNG
Is there a way that when a cell is selected it will highlight the cell and all of the cells along the same row?
View 12 Replies View Related
