Is it possible to link two cells and maintain the source cells format?

Thanks

JG

You mean if you change the format of the "sending" cell, will the "receiving"
cell inherit this formatting?

If that's what you mean, then nope. Formulas return values--not this kind of
formatting.



Jon Goff wrote:

Is it possible to link two cells and maintain the source cells format?

Thanks

JG

--
Jon Goff

--

Dave Peterson

No.


Check the following under Troubleshhot Conditional Format:


Conditional formats are not applied correctly.

Check for multiple conditions If you specify multiple conditions and more
than one condition is met, Microsoft Excel applies only the formats for the
first true condition.
See whether conditions overlap If you specify conditions that overlap,
Excel applies only the format of the first true condition. For example, if
you specify a condition that applies yellow shading to cell values between
100 and 200, inclusive, and then you specify a second condition that applies
red shading to cell values below 120, the cell values of 100 through
119.999999999999 will appear with yellow shading. Its best to avoid
overlapping conditions.

Check cell references If you used a formula as the formatting criteria,
the cell references (cell reference: The set of coordinates that a cell
occupies on a worksheet. For example, the reference of the cell that appears
at the intersection of column B and row 3 is B3.) in the formula might not be
correct.
The settings I applied in the Conditional Formatting dialog box are now blank.

The current selection might include cells that have two or more types of
conditional formatting. The dialog box can display only one set of
conditional formatting criteria and cell formats at a time.

Select different cells and check the settings again.

I can't use some formats as conditional formats.

Cell formats that can change the row height or column width cannot be used
as conditional formats.

Formats such as font color and cell shading automatically change.

If conditional formats (conditional format: A format, such as cell shading
or font color, that Excel automatically applies to cells if a specified
condition is true.) have been applied to a cell, Microsoft Excel applies the
formats depending on whether the cell value or other evaluated data meets a
condition you specified.

If you base the formatting condition on the value of the selected cells,
cells that contain text are evaluated as ASCII strings. Formats such as bold
or the font color may change if you change the text.
Conditional formats have priority over formats that you apply directly to a
cell by using the Cells command (Format menu) or a Formatting toolbar
(toolbar: A bar with buttons and options that you use to carry out commands.
To display a toolbar, press ALT and then SHIFT+F10.) button. If a specified
condition is true, the formats for that condition override the manual
formatting.

Challa Prabhu

"Jon Goff" wrote:


Is it possible to link two cells and maintain the source cells format?

Thanks

JG




--
Jon Goff

Challa,

I have been trying to reflect the change of color in llinked cells from on
sheet to another. The value changes but not color, do you know how to do
that. Do I have to make a macro?
Sofia

"challa prabhu" wrote:


No.


Check the following under Troubleshhot Conditional Format:


Conditional formats are not applied correctly.

Check for multiple conditions If you specify multiple conditions and more
than one condition is met, Microsoft Excel applies only the formats for the
first true condition.
See whether conditions overlap If you specify conditions that overlap,
Excel applies only the format of the first true condition. For example, if
you specify a condition that applies yellow shading to cell values between
100 and 200, inclusive, and then you specify a second condition that applies
red shading to cell values below 120, the cell values of 100 through
119.999999999999 will appear with yellow shading. Its best to avoid
overlapping conditions.

Check cell references If you used a formula as the formatting criteria,
the cell references (cell reference: The set of coordinates that a cell
occupies on a worksheet. For example, the reference of the cell that appears
at the intersection of column B and row 3 is B3.) in the formula might not be
correct.
The settings I applied in the Conditional Formatting dialog box are now blank.

The current selection might include cells that have two or more types of
conditional formatting. The dialog box can display only one set of
conditional formatting criteria and cell formats at a time.

Select different cells and check the settings again.

I can't use some formats as conditional formats.

Cell formats that can change the row height or column width cannot be used
as conditional formats.

Formats such as font color and cell shading automatically change.

If conditional formats (conditional format: A format, such as cell shading
or font color, that Excel automatically applies to cells if a specified
condition is true.) have been applied to a cell, Microsoft Excel applies the
formats depending on whether the cell value or other evaluated data meets a
condition you specified.

If you base the formatting condition on the value of the selected cells,
cells that contain text are evaluated as ASCII strings. Formats such as bold
or the font color may change if you change the text.
Conditional formats have priority over formats that you apply directly to a
cell by using the Cells command (Format menu) or a Formatting toolbar
(toolbar: A bar with buttons and options that you use to carry out commands.
To display a toolbar, press ALT and then SHIFT+F10.) button. If a specified
condition is true, the formats for that condition override the manual
formatting.

Challa Prabhu

"Jon Goff" wrote:


Is it possible to link two cells and maintain the source cells format?

Thanks

JG




--
Jon Goff

Sofia wrote:
Challa,

I have been trying to reflect the change of color in llinked cells from on
sheet to another. The value changes but not color, do you know how to do
that. Do I have to make a macro?
Sofia

No.

[quoted text clipped - 56 lines]

JG


You will have to copy / paste your ranges
You may want to pastespecial values & formats.

I know it's a bind, but that's the way it is.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200705/1