cell colour
 

In a workbook i use i have a cell that has the following formula so it stays
the same value as another cell e.g.

=sheet2!$B$1

No problem. But what formula can i use so that the cell has the same value
and colour?, if i change the colour of the cell B2 i want the colour to
automatically change in the other cell.
Thanks

cell colour
 

A formula can only change the VALUE that is displayed; it cannot change the
format. You would need some VBA code to do that.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"jackrobyn1" wrote in message
...
In a workbook i use i have a cell that has the following formula so it
stays
the same value as another cell e.g.

=sheet2!$B$1

No problem. But what formula can i use so that the cell has the same value
and colour?, if i change the colour of the cell B2 i want the colour to
automatically change in the other cell.
Thanks

cell colour
 

Formulas can't return this kind of formatting. Formulas return values.

jackrobyn1 wrote:

In a workbook i use i have a cell that has the following formula so it stays
the same value as another cell e.g.

=sheet2!$B$1

No problem. But what formula can i use so that the cell has the same value
and colour?, if i change the colour of the cell B2 i want the colour to
automatically change in the other cell.
Thanks

--

Dave Peterson

cell colour
 

You cannot link color or other formatting, only values
--
Gary''s Student - gsnu200749


"jackrobyn1" wrote:

In a workbook i use i have a cell that has the following formula so it stays
the same value as another cell e.g.

=sheet2!$B$1

No problem. But what formula can i use so that the cell has the same value
and colour?, if i change the colour of the cell B2 i want the colour to
automatically change in the other cell.
Thanks

cell colour
 

Use conditional formatting to set the cell color, and use the same
expression in both cells.

jackrobyn1 wrote:

In a workbook i use i have a cell that has the following formula so it stays
the same value as another cell e.g.

=sheet2!$B$1

No problem. But what formula can i use so that the cell has the same value
and colour?, if i change the colour of the cell B2 i want the colour to
automatically change in the other cell.
Thanks