Automatic Copying Of Formatting
Sep 11, 2009
Is there a way to copy the formatting of a cell automatically? For example, if you just do "=B1", then the cell with this formula will automatically update with whatever cell B1 contains whenever it is changed.
But is there a way to do the same thing with formatting? So if cell B1 was bolded, or changed the cell color, or conditional formatting, is there a way the cell that is referenced to B1 would also automatically change to whatever the formatting change is?
View 3 Replies
ADVERTISEMENT
Jan 17, 2013
I have a workbook with so many sheets as the working days of a month. I also have a Master sheet.
The sheets are named as the dates. Example: 020113 , 020113, 030113......etc
In the Master sheet, first column has ALL working dates of the month(i don't care about Holidays).
First row of this sheet are headers.
My goal is from the sheet of the certain date of the month automatic copied certain cells values(same in eatch sheet) to certain cells in Master Sheet.
View 7 Replies
View Related
Jan 29, 2013
I have been asked to create a clash grid that shows when promotions for specific customers are on for specific products.
I've got all the information collated, and I suck it all up into a cover sheet that splits it by product, by customer, and then shows the weeks each product is on promotion. The issue I have, is I wish to colour code each customer so it is easier to read for those who aren't excel savvy.
I've tried conditionally formatting it, but have stumbled a couple of times. I can write an 'if' statement for it, but can't work out how to get the conditional formatting to follow the statement (I'm not sure this is the best way to do it, but figured it was worth explaining).
Attached is a 'How it is' and 'What I want it to be'.
StarkeyExample.xlsx
View 5 Replies
View Related
Dec 4, 2013
In the attached spreadsheet, I have a limit value which is used to set the color of other cells based on their values.
So if the value is greater than limit, the color is red.
When I change the limit, I do see the changes in color.
However, I also want to show only the red values.
View 5 Replies
View Related
Oct 2, 2008
So the title isn't really totally descriptive but it was all I could come up with. I have a work book that has 30 identical sets of 5 cells for users to enter in information. Some of my users will not need all 30 sets. I'm wondering if there is a way for the user to enter the number of cells they need and have excel then format so they have the desired number, instead of 30. Then have excel change all the instances of this number in formulas so that it matches the new number of cells. I hope I explained this well enough for someone to help.
View 9 Replies
View Related
Jul 22, 2014
I have a long set of data that I extract a "table" out of based on index matching controlled by 4 different criteria. This part is working as intended. However I need to format the cells with the corresponding "fetched data" based on another criteria. Makes sense? Have a look at a spreadsheet i made representing my problem. It has comments for the problems.
excel tableformatting problem.xlsx‎
View 1 Replies
View Related
Sep 1, 2006
When opening a CSV file in Excel, it seems Excel makes an "intelligent" attempt at interpreting the data into a data type.
This causes a text field containing 7300070E-4 to be interpreted as 7.30E+0
View 9 Replies
View Related
Oct 23, 2007
I have to copy the formatting from "rows G&H" for 40,000+ lines. Is there an easier way than doing the formatting then highlighting the first two cells (G4 and H4) then dragging the bottom right hand corner down 40,000 lines?
View 5 Replies
View Related
Nov 24, 2011
I am having trouble copying conditional formatting down my spreadsheet. When i copy it the number dont change. the formula i have in the conditional formatting is =O3
View 9 Replies
View Related
Aug 26, 2009
Cell (A1) is formatted differently from the other cells of the same column. I added to it a conditional formatting (based on a formula) which I want to copy [alone] to the rest of the cells, without getting the other different formatting of cell (A1) copyed as well.
View 9 Replies
View Related
May 10, 2007
I use excel 2003. To improve readability, I have formatted each line to have a slightly different background color (white for odd ines, light gray for even). Sometimes when I edit, I use Control + D to fill down a column with the data or formula from the 1st cell. However, when I do that the background formatting is copied too and it messes up the alternating colored lines. Is the a way to fill down only the data/formulas and not the color/pattern?
View 3 Replies
View Related
Sep 3, 2013
I am working on a check box based list for work. The requirement is for the check box to be linked to the cell that it is in and then for conditional formatting to be done so that if the box is checked it goes green and if it is blank it goes red. This is fine for individual cells, but when i try and copy the formatting and cells throughout the worksheet it links all the cells back to the original cell.
View 7 Replies
View Related
Feb 1, 2013
I have a set of values on Sheet1. These 'original' values will never change.
I then have a set of values on Sheet2. The 'updated' values get updated every month.
On Sheet3 I want to show the updated values again, pretty much a copy of Sheet2, but where a value is higher than that on Sheet1 or lower than a value on Sheet1 I want to use conditional formatting to show this.
Is there a simple way to use conditional formatting in such a way? I have a long list of values so don't want to individually create a rule for each cell.
View 6 Replies
View Related
Oct 31, 2009
is it possible, after inserting new sheet rows, to automate the copying of formulas and cell formatting into the newly created space, instead of manually copying the formulas and formatting down into each column?
View 6 Replies
View Related
Oct 28, 2013
I have a piece of code that runs through various excel files and takes the data (minus the header) and pastes that into a separate workbook. The piece of code that does the actual copying i think is this (i have used code from the msdn website)
Code:
With sourceRange
Set destrange = destrange. _
Resize(.Rows.Count, .Columns.Count)
End With
destrange.Value = sourceRange.Value
I have tried replacing the sourceRange.Value with sourceRange.Text however when i do that it will copy nothing any more.
View 2 Replies
View Related
Feb 12, 2013
i am trying to import an excel document and then copy over some columns to another worksheet from the imported worksheet, using a macro. Everything imports and copies over fine except for one column that has cells that comprise of a list of number separated by commas. When these cells get copied over some of the values retain the commas but some of them (specially when there are a lot values separated by comma) gets changed to this format
From: 1,229,124,012,441,230
To: 1.22912E+15
From: 1044,1048,1052,1053
To: 1.0441E+15
From: 1279,1282,1286,1295,1299
To: 1.27913E+19
From:926,929,938
To: 926929938
I am trying to figure out whats happening here! Is there a max number of letters this column can take and if it exceeds that value, excel converts them to this format? Or is the formatting gets changed to something else while copying and pasting?
View 3 Replies
View Related
Jul 9, 2013
I have applied conditional formatting to a cell using formulas and i want to copy that formatting to a new cell using similar formula but pointing to different cells. Is it possible to do so? I have tried to copy and paste special>formats, but that just copies the conditional formatting with the same formulas.
Sample: =IF($C$5/$C$295>$R$5,TRUE,FALSE)
I want to copy to $D$5/$D$295>$R$5,TRUE,FALSE) without having to paste the new formula in each time.
View 9 Replies
View Related
Jun 29, 2007
I am having a problem with a excel spreadsheet. There are no formulas or anything, just text that I used excel to get everything lined up. I haven't had any issues before, I was copying and pasting within a document. It was all text with different row heights set. I ran into a problem now where the text copies and pastes fine but the row heights aren't coping into the cells I am pasting into, just the text. What do I have to do so they will copy? I don't want to have to go an individually adjust each cell.
View 2 Replies
View Related
Mar 19, 2013
How to copy and paste conditional formatting with our changing the cell values. My first row of data starts in row 4 and here is what I have in D4
If D4 is less than or equal to AA4, AW4, BS4, CO4 then it will highlight D4
Now I want to copy that format and paste it for all rows in column D. The problem I'm having though is when I paste the formula it doesn't change to match the row I'm on. For example, when I paste it in D5 this is what I get
If D5 is less than or equal to AA4, AW4, BS4, CO4 then it will highlight D5
How do I paste it so that it will update to show AA5, AW5, BS5, and CO5. I want to be able to do this for 500 rows.
View 6 Replies
View Related
May 2, 2012
I have a workbook containing two worksheets of staff training records.
The first work sheet contains a list of names and the dates they completed various training courses. I have used some simple date based formulas and conditional formatting to colour-code their name depending on whether their earliest retraining due date has passed, is coming up in the next few weeks, or is a long way off. The data is set out alphabetically, one person per row of data.
The second sheet contains the same list of names, but each person's data is split across two consecutive rows. The cells in column A which contain the staff names are merged in pairs so that the name heads both rows of data.
I want the colour coding of the merged name cells in sheet 2 to automatically copy the colour coding applied to the single name cell in sheet 1, but don't know how.
I'm using excel 2010.
View 3 Replies
View Related
Jun 6, 2012
Excel 2007.
I have conditional formatting set up so that the cell becomes highlighted if it contains a specific text.
Example of wanted conditional formatting:
Conditional formatting rules manager
Rule
Format
Applies to
Stop if true
[Code] ......
For some reason this formatting is inherited by another adjacent cell as we continue to input information.
For example:
Column M is formatted so if 'AP' is placed in any cell in that column the cell fills pink. As more information is inputted into the sheet, the conditional formatting copies to Column N. It does not happen with every entry and I have not been able to isolate the specific steps to recreate the copying. Multiple people use the same sheet and fill it out and needed.
After working with the sheet changes are made to the "applies to" column without people meaning to.
For example:
Conditional formatting rules manager
Rule
Format
Applies to
[Code] .......
I would like to make this formatting so that is only applies to the Column M and not "travel" to other cells of the sheet.
View 2 Replies
View Related
May 15, 2014
I want to copy the current region on sheet 3 and paste that into sheet2 starting with cell E4. But I don't want to actually use the copy method. I believe there is a way to do this. I was thinking the following:
[Code] ......
The idea I had was to simply state that cell E4 would be assigned the value of CurrentRegion on sheet 3. Is there a way to bypass the copy method?
If not, how to copy, then paste?
View 2 Replies
View Related
Dec 12, 2007
I am trying to make the cells Iam am copying paste hidden cells with all formats - seems to work fine other than the security part of them, Iam makeing a sheet for work and just trying to make it were it will not get destroyed by other users-
View 12 Replies
View Related
Apr 27, 2014
i have created a table. when i m editing new row then formulas is copying bu value is not copying ?
View 3 Replies
View Related
Sep 16, 2013
A little background on what i am doing. I have a spreadsheet that tracks when i have blown the dust out of our computers. I have set up conditional formatting so that the text turns red after 300 days and the cell turns yellow after 600 days. However, some computers are in high dust environments. I would like the spreadsheet to tell me to blow the dust out of these sooner. see the attached sheet.
dust 1.xlsx
View 2 Replies
View Related
May 11, 2007
I have a table which holds scores as well as other data for players. Is it possible to automatically sort a table based on their points score to see who is top of the league?
View 9 Replies
View Related
Mar 19, 2009
I’m aware of the AutoRecovery, but I’m looking for an Autoback (Auto save) itself. Is there one in Excel? ( I'm using 2003)
View 2 Replies
View Related
Feb 14, 2010
I’m not even sure I can do this- but- I want to be able to have a few columns, 3 of them I want to be Item #, Item, Cost.
Is there a way to put the Item # (Number) in, then have the other 2 automatically come up?
View 9 Replies
View Related
Jul 13, 2007
I am inputing each day the total amount of sales. I am manually doing the averages for past 12 weeks on Monday sheet. I would like when I enter the amount for that week that the cells B84, C84, E84, F84 are automatically updated for the past 12 weeks. I have tried a few different approaches but I keep getting #ref or circular reference
View 10 Replies
View Related
Dec 18, 2007
I'm trying to create a bug reporting tool (with a bunch of text boxes and drop down lists) and have the following problems...
1. I would like to get a unique number inserted automatically in a textbox (it's supposed to be the bugs id (1001). How do I do this? And when I click OK after inserting all info I want this number to become +1 so the next defect can be added immediately.
2. Why are my drop down lists empty as default and their values only appear if I enter a value. Why aren't the lists displayed when i just click on them?
3. I have a multipel row text box. How do I get the text to jump to the next row automatically instead of using crtl + enter?
View 12 Replies
View Related
