Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Using = sign will link data between sheets but not colour. Why?
If I put = in a cell in sheet 1 and then click on a cell in sheet 2 and press
'enter' it transfers only the text in the sheet 2 cell not the colour of the cell. Is there anyway that I can get it to transfer the cell colour as well? |
#2
|
|||
|
|||
Copy and paste???
Formulas return values--not formats. Laurie21 wrote: If I put = in a cell in sheet 1 and then click on a cell in sheet 2 and press 'enter' it transfers only the text in the sheet 2 cell not the colour of the cell. Is there anyway that I can get it to transfer the cell colour as well? -- Dave Peterson |
#3
|
|||
|
|||
The colour represents of a cell represents the status of the project on which
I am working, it is therefore subject to change. When I change the colour in a cell sheet 1 it does not alter the colour of the corresponding cell (=) in sheet two. Is there a way to solve this problem? "Dave Peterson" wrote: Copy and paste??? Formulas return values--not formats. Laurie21 wrote: If I put = in a cell in sheet 1 and then click on a cell in sheet 2 and press 'enter' it transfers only the text in the sheet 2 cell not the colour of the cell. Is there anyway that I can get it to transfer the cell colour as well? -- Dave Peterson |
#4
|
|||
|
|||
Copy and paste--even via a macro would work.
Any chance you could use format|conditional formatting for both cells--with the same rules? Laurie21 wrote: The colour represents of a cell represents the status of the project on which I am working, it is therefore subject to change. When I change the colour in a cell sheet 1 it does not alter the colour of the corresponding cell (=) in sheet two. Is there a way to solve this problem? "Dave Peterson" wrote: Copy and paste??? Formulas return values--not formats. Laurie21 wrote: If I put = in a cell in sheet 1 and then click on a cell in sheet 2 and press 'enter' it transfers only the text in the sheet 2 cell not the colour of the cell. Is there anyway that I can get it to transfer the cell colour as well? -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
What is a macro? - sorry I am a computer novice. When i tried conditional
formating it said that "you may not use references to other worksheets or workbooks for Conditional Formatting criteria" "Dave Peterson" wrote: Copy and paste--even via a macro would work. Any chance you could use format|conditional formatting for both cells--with the same rules? Laurie21 wrote: The colour represents of a cell represents the status of the project on which I am working, it is therefore subject to change. When I change the colour in a cell sheet 1 it does not alter the colour of the corresponding cell (=) in sheet two. Is there a way to solve this problem? "Dave Peterson" wrote: Copy and paste??? Formulas return values--not formats. Laurie21 wrote: If I put = in a cell in sheet 1 and then click on a cell in sheet 2 and press 'enter' it transfers only the text in the sheet 2 cell not the colour of the cell. Is there anyway that I can get it to transfer the cell colour as well? -- Dave Peterson -- Dave Peterson |
#6
|
|||
|
|||
Simply, you can't link color changes. If you are manually changing the color
of the first cell based on your project status, there is no way to automatically change the color of the second (linked) cell to the same color. You could do it using a macro, but it would be just as simple to change the color of the second cell manually. -- Vasant "Laurie21" wrote in message ... What is a macro? - sorry I am a computer novice. When i tried conditional formating it said that "you may not use references to other worksheets or workbooks for Conditional Formatting criteria" "Dave Peterson" wrote: Copy and paste--even via a macro would work. Any chance you could use format|conditional formatting for both cells--with the same rules? Laurie21 wrote: The colour represents of a cell represents the status of the project on which I am working, it is therefore subject to change. When I change the colour in a cell sheet 1 it does not alter the colour of the corresponding cell (=) in sheet two. Is there a way to solve this problem? "Dave Peterson" wrote: Copy and paste??? Formulas return values--not formats. Laurie21 wrote: If I put = in a cell in sheet 1 and then click on a cell in sheet 2 and press 'enter' it transfers only the text in the sheet 2 cell not the colour of the cell. Is there anyway that I can get it to transfer the cell colour as well? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i find data in multiple sheets in excel | Excel Worksheet Functions | |||
link source data | Excel Discussion (Misc queries) | |||
how do i link data from multiple standardized excel files | Excel Discussion (Misc queries) | |||
Updating Excel Data on Multiple Sheets | Excel Worksheet Functions | |||
Summary of data from 20 sheets | Excel Discussion (Misc queries) |