Re: [libreoffice-users] Cell references - apply formats too?

2013-07-19 Thread er...@xe4.org
Charles asked Is it possible to have a cell on one worksheet that references a cell on another worksheet to also reflect the FORMAT of the referenced cell? Ie, if the referenced cell has a red background, the cell referencing it should also have a red background? Yes, using conditional forma

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-19 Thread Tanstaafl
On 2013-07-19 9:11 AM, Brian Barker wrote: At 06:44 19/07/2013 -0400, Charles Marcus wrote: On 2013-07-18 10:52 PM, Brian Barker wrote: What you can do, of course, is to set up another column or row in which you put suitable values which can then control conditional formatting of both the targ

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-19 Thread Brian Barker
At 06:44 19/07/2013 -0400, Charles Marcus wrote: On 2013-07-18 10:52 PM, Brian Barker wrote: What you can do, of course, is to set up another column or row in which you put suitable values which can then control conditional formatting of both the target cell and the referencing one. To change

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-19 Thread Tom Davies
hough i seem to remember the last person asking about this got his task done some other way.  Regards from Tom :)  > > From: Tanstaafl >To: users@global.libreoffice.org >Sent: Friday, 19 July 2013, 11:44 >Subject: Re: [libreoffice-users] Cell

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-19 Thread Tanstaafl
On 2013-07-18 10:52 PM, Brian Barker wrote: What you can do, of course, is to set up another column or row in which you put suitable values which can then control conditional formatting of both the target cell and the referencing one. To change the background of both, you merely need to change

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-18 Thread Brian Barker
At 00:52 19/07/2013 +0200, Errol Goetsch wrote: [Someone asked:] Is it possible to have a cell on one worksheet that references a cell on another worksheet to also reflect the FORMAT of the referenced cell? Ie, if the referenced cell has a red background, the cell referencing it should also ha

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-18 Thread Brian Barker
At 10:53 18/07/2013 -0400, Charles Marcus wrote: Is it possible to have a cell on one worksheet that references a cell on another worksheet to also reflect the FORMAT of the referenced cell? Ie, if the referenced cell has a red background, the cell referencing it should also have a red backgrou

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-18 Thread Errol Goetsch
Is it possible to have a cell on one worksheet that references a cell on another worksheet to also reflect the FORMAT of the referenced cell? Ie, if the referenced cell has a red background, the cell referencing it should also have a red background? Yes, using conditional formats. First create fo

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-18 Thread Tom Davies
ice.org >Sent: Thursday, 18 July 2013, 15:53 >Subject: [libreoffice-users] Cell references - apply formats too? > > >Is it possible to have a cell on one worksheet that references a cell on >another worksheet to also reflect the FORMAT of the referenced cell? Ie, >if the r

[libreoffice-users] Cell references - apply formats too?

2013-07-18 Thread Tanstaafl
Is it possible to have a cell on one worksheet that references a cell on another worksheet to also reflect the FORMAT of the referenced cell? Ie, if the referenced cell has a red background, the cell referencing it should also have a red background? Thanks -- To unsubscribe e-mail to: users+u