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+unsubscr...@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