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???
|