Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to keep font color when referencing Sheets in the same workboo
In the same workbook (Office 2007):
In Sheet 2, in Cell A1 I have the word "Michigan" in red font. In Sheet 1 at Cell B3 I want to reference the above cell "=Sheet1!A1" Michigan is displayed according to play, but the font color changes to the default black. Is there any way to keep the color attribute??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to keep font color when referencing Sheets in the same workboo
If the font color was set with conditional formatting, you can format the
second sheet/cell the same way. If you want it to match, you'll need to do something with VBA, although I'm not exactly sure how I'd approach it. -- HTH, Barb Reinhardt "AdirondackSam" wrote: In the same workbook (Office 2007): In Sheet 2, in Cell A1 I have the word "Michigan" in red font. In Sheet 1 at Cell B3 I want to reference the above cell "=Sheet1!A1" Michigan is displayed according to play, but the font color changes to the default black. Is there any way to keep the color attribute??? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to keep font color when referencing Sheets in the same wor
Thank you Barb, but conditional formatting is not used.
This is simple input using a RED color on the font as described in the original post. I'm just trying to carry the font color over to another spreadsheet by reference. "Barb Reinhardt" wrote: If the font color was set with conditional formatting, you can format the second sheet/cell the same way. If you want it to match, you'll need to do something with VBA, although I'm not exactly sure how I'd approach it. -- HTH, Barb Reinhardt "AdirondackSam" wrote: In the same workbook (Office 2007): In Sheet 2, in Cell A1 I have the word "Michigan" in red font. In Sheet 1 at Cell B3 I want to reference the above cell "=Sheet1!A1" Michigan is displayed according to play, but the font color changes to the default black. Is there any way to keep the color attribute??? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to keep font color when referencing Sheets in the same wor
Cannot be done without some type of code, macro or event.
BTW..........your example formula has a typo "=Sheet1!A1" should be =Sheet2!A1 or you have your sheets mixed up Here is a macro you could run on Sheet1 assuming it has the linking formulas. Sub format_link_cells() Dim myCell As Range For Each myCell In Selection If myCell.Value = Sheets("Sheet2").Range(myCell.Address).Value Then myCell.Interior.ColorIndex = Sheets("Sheet2") _ .Range(myCell.Address).Interior.ColorIndex Else: myCell.Interior.ColorIndex = xlNone End If Next myCell End Sub Gord Dibben MS Excel MVP On Tue, 9 Sep 2008 20:06:01 -0700, AdirondackSam wrote: Thank you Barb, but conditional formatting is not used. This is simple input using a RED color on the font as described in the original post. I'm just trying to carry the font color over to another spreadsheet by reference. "Barb Reinhardt" wrote: If the font color was set with conditional formatting, you can format the second sheet/cell the same way. If you want it to match, you'll need to do something with VBA, although I'm not exactly sure how I'd approach it. -- HTH, Barb Reinhardt "AdirondackSam" wrote: In the same workbook (Office 2007): In Sheet 2, in Cell A1 I have the word "Michigan" in red font. In Sheet 1 at Cell B3 I want to reference the above cell "=Sheet1!A1" Michigan is displayed according to play, but the font color changes to the default black. Is there any way to keep the color attribute??? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to keep font color when referencing Sheets in the same wor
Gord:
Correct you are on the error and than you for pointing that out. I will try your Macro and see if I can get it to work, but you at least confirmed what I suspected --- there's no easy simple way to carry the formatting over from one sheet to another. So at least I can stop searching the 'help' files and banging my head against a wall. Thanks!!!! "Gord Dibben" wrote: Cannot be done without some type of code, macro or event. BTW..........your example formula has a typo "=Sheet1!A1" should be =Sheet2!A1 or you have your sheets mixed up Here is a macro you could run on Sheet1 assuming it has the linking formulas. Sub format_link_cells() Dim myCell As Range For Each myCell In Selection If myCell.Value = Sheets("Sheet2").Range(myCell.Address).Value Then myCell.Interior.ColorIndex = Sheets("Sheet2") _ .Range(myCell.Address).Interior.ColorIndex Else: myCell.Interior.ColorIndex = xlNone End If Next myCell End Sub Gord Dibben MS Excel MVP On Tue, 9 Sep 2008 20:06:01 -0700, AdirondackSam wrote: Thank you Barb, but conditional formatting is not used. This is simple input using a RED color on the font as described in the original post. I'm just trying to carry the font color over to another spreadsheet by reference. "Barb Reinhardt" wrote: If the font color was set with conditional formatting, you can format the second sheet/cell the same way. If you want it to match, you'll need to do something with VBA, although I'm not exactly sure how I'd approach it. -- HTH, Barb Reinhardt "AdirondackSam" wrote: In the same workbook (Office 2007): In Sheet 2, in Cell A1 I have the word "Michigan" in red font. In Sheet 1 at Cell B3 I want to reference the above cell "=Sheet1!A1" Michigan is displayed according to play, but the font color changes to the default black. Is there any way to keep the color attribute??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i link one sheet to another sheets cell of the same workboo | Excel Discussion (Misc queries) | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
Can columns be hidden accross multiple sheets in an Excel workboo | Excel Worksheet Functions | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) |