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?

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

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

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

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

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