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

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 have a red background?
>
> Yes, using conditional formats.
> First create format styles with F11, then tell the cell to apply the 
> format appropriate to the value of a referenced cell.
>
> In the example at 
> https://docs.google.com/file/d/0B6LXy9sguZVkVDdMMXh3Y1dhQWs/edit?usp=sharing
> c2 - n2 are months Jan to Dec, b3 - b12 are 10 salespersons and c3 - 
> n12 are their monthly sales. We want to use colours to quickly see 
> who sold the most and least each month.
> c15 - n15 show the min sales in each column (and are formatted white 
> on red. This is per style named "Min")
> c17 - n17 show the max sales in each column (and are formatted white 
> on blue. This is per style named "Max")
>
> In the conditional formatting for each cell c3 - n12,
> 1. apply style Min if the cell contents = cell in row 15 and
> 2. apply style Max if the cell = row 17.
>
> What you achieve is 2 cells in each column automatically turning red 
> or blue if they match other cells based on their value, allowing 
> high or low achievers to be immediately recognised.

Sorry to be a wet blanket, but this appears to show how the format of 
the destination cell can be made to depend on the value, not the 
format, of another cell.  If I change the format of your Min and Max 
value rows - say to give them green backgrounds - the cells 
highlighted by conditional formatting still appear in red and blue - 
according to your Min and Max cell styles.  It's very pretty and well 
designed and no doubt useful, but it doesn't quite do what I think 
the questioner is asking for.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted