Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to carry formatting to a different sheet?
e.g.
If cell A1 in Sheet 1 contains "This is a Statement" and the word 'Statement' is formatted in color Red and/or a different font and A1 on Sheet 2 contains something like: ='Input Sheet'!$A$1 can I get it to show up the same on Sheet2 in cell A1? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to carry formatting to a different sheet?
You would need a macro rather than a simple link expression.
-- Gary's Student "ZBC2" wrote: e.g. If cell A1 in Sheet 1 contains "This is a Statement" and the word 'Statement' is formatted in color Red and/or a different font and A1 on Sheet 2 contains something like: ='Input Sheet'!$A$1 can I get it to show up the same on Sheet2 in cell A1? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
Copying and Pasting from One Sheet to Another | Setting up and Configuration of Excel | |||
How to get a row consecutive from a sheet to another | Excel Worksheet Functions | |||
How do I copy formatting from 1 sheet to next in same workbook? | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |