L
L. Davis
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?
How do I link the formatting of that link cell as well?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
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.
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.
L
L. Davis
I don't believe you can use Conditional formating on different worksheets.
D
Dave Peterson
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.
Format|conditional format|rules.
In xl2003, there's only 3 CF rules (plus the normal format) that I can use. So
it's limited.
G
Gord Dibben
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
And you can CF A1 on sheet2 to red if value is 23
Select both sheets and enter your CF for A1
Gord