How i get the fill color of a cell on page 2 when its linked to a cell on
page 1
--
Bill McClelland

If the source fill color is due to Conditional Formatting, replacate that CF
in the target cell.

Otherwise...........linked formulas, as all formulas, return values only,
not formatting.


Gord Dibben MS Excel MVP

On Wed, 27 Aug 2008 13:28:05 -0700, Billmc0714
wrote:

How i get the fill color of a cell on page 2 when its linked to a cell on
page 1

--
Bill McClelland


"Gord Dibben" wrote:

If the source fill color is due to Conditional Formatting, replacate that CF
in the target cell.

Otherwise...........linked formulas, as all formulas, return values only,
not formatting.


Gord Dibben MS Excel MVP

On Wed, 27 Aug 2008 13:28:05 -0700, Billmc0714
wrote:

How i get the fill color of a cell on page 2 when its linked to a cell on
page 1

I dont think i was very clear in my question so I will try again On page 1 I
have cell 1 a with a value and a cell color and I want to change both the
cell value and the cell cover I know if I use Conditional Formating the value
will change on page 2 but i can not get the cell color to change on page 2
without manually changing it the condtional formating does not change the
cell color on page when I change it on page 1
--
Bill McClelland


"Gord Dibben" wrote:

If the source fill color is due to Conditional Formatting, replacate that CF
in the target cell.

Otherwise...........linked formulas, as all formulas, return values only,
not formatting.


Gord Dibben MS Excel MVP

On Wed, 27 Aug 2008 13:28:05 -0700, Billmc0714
wrote:

How i get the fill color of a cell on page 2 when its linked to a cell on
page 1

I thought your first post was clear.

You want to link a cell on sheet2 to a value in a colored cell on sheet1.

You want to also link the formatting of sheet1 cell.

Cannot be done without CF for value on both cells.

I don't know what you're trying for CF but if sheet1 CF is something like

Cell value = <123 use the same CF on sheet2


Gord

On Thu, 28 Aug 2008 07:06:01 -0700, Billmc0714
wrote:

I dont think i was very clear in my question so I will try again On page 1 I
have cell 1 a with a value and a cell color and I want to change both the
cell value and the cell cover I know if I use Conditional Formating the value
will change on page 2 but i can not get the cell color to change on page 2
without manually changing it the condtional formating does not change the
cell color on page when I change it on page 1

Excel gives me an error message and i quote "You can not refernce another
work page or work shett when using Conditional Formating"
--
Bill McClelland


"Gord Dibben" wrote:

I thought your first post was clear.

You want to link a cell on sheet2 to a value in a colored cell on sheet1.

You want to also link the formatting of sheet1 cell.

Cannot be done without CF for value on both cells.

I don't know what you're trying for CF but if sheet1 CF is something like

Cell value = <123 use the same CF on sheet2


Gord

On Thu, 28 Aug 2008 07:06:01 -0700, Billmc0714
wrote:

I dont think i was very clear in my question so I will try again On page 1 I
have cell 1 a with a value and a cell color and I want to change both the
cell value and the cell cover I know if I use Conditional Formating the value
will change on page 2 but i can not get the cell color to change on page 2
without manually changing it the condtional formating does not change the
cell color on page when I change it on page 1

Why are you trying to reference sheet1 cell on sheet2 in CF?

The link is already there, just give sheet2 cell same CF as sheet1 cell.


Gord Dibben MS Excel MVP

On Thu, 28 Aug 2008 07:48:00 -0700, Billmc0714
wrote:

Excel gives me an error message and i quote "You can not refernce another
work page or work shett when using Conditional Formating"