Thread: How to keep font color when referencing Sheets in the same workboo
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AdirondackSam AdirondackSam is offline
external usenet poster
  
Posts: 5
Default 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???
Reply With QuoteReply With Quote