Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I keep my formatting when linking cells in diff. sheets?
I understand how to link a cell to another cell in a different worksheet.
How do I link the formatting of that link cell as well? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I keep my formatting when linking cells in diff. sheets?
You don't by using a link only.
Maybe format both cells with identical Conditional Formatting? Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 10:35:01 -0700, L. Davis <L. wrote: I understand how to link a cell to another cell in a different worksheet. How do I link the formatting of that link cell as well? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I keep my formatting when linking cells in diff. sheets
I don't believe you can use Conditional formating on different worksheets.
"Gord Dibben" wrote: You don't by using a link only. Maybe format both cells with identical Conditional Formatting? Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 10:35:01 -0700, L. Davis <L. wrote: I understand how to link a cell to another cell in a different worksheet. How do I link the formatting of that link cell as well? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I keep my formatting when linking cells in diff. sheets
If I name a range on a different sheet, I can use that name in the
Format|conditional format|rules. In xl2003, there's only 3 CF rules (plus the normal format) that I can use. So it's limited. L. Davis wrote: I don't believe you can use Conditional formating on different worksheets. "Gord Dibben" wrote: You don't by using a link only. Maybe format both cells with identical Conditional Formatting? Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 10:35:01 -0700, L. Davis <L. wrote: I understand how to link a cell to another cell in a different worksheet. How do I link the formatting of that link cell as well? -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I keep my formatting when linking cells in diff. sheets
But you can CF A1 on Sheet1 to red if value is 23
And you can CF A1 on sheet2 to red if value is 23 Select both sheets and enter your CF for A1 Gord On Mon, 9 Mar 2009 11:48:01 -0700, L. Davis wrote: I don't believe you can use Conditional formating on different worksheets. "Gord Dibben" wrote: You don't by using a link only. Maybe format both cells with identical Conditional Formatting? Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 10:35:01 -0700, L. Davis <L. wrote: I understand how to link a cell to another cell in a different worksheet. How do I link the formatting of that link cell as well? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how you make links between diff. cells on diff. work sheets | Excel Worksheet Functions | |||
Linking cells between sheets | Excel Worksheet Functions | |||
Linking cells between sheets | Excel Worksheet Functions | |||
Linking cells between sheets | Excel Worksheet Functions | |||
how to add many cells on diff. sheets and put in 1 cell in excel | Excel Worksheet Functions |