Posted: Wed Jan 30, 2008 8:55 am Post subject: New page about automatic coloring of rows in Calc
From this thread on the forum. Thanks yoxi for having provided the tip.
I've added the possibility of having three different colors. Does anyone know if it's possible to impose more than 3 conditions in conditional formatting?
version française English version (you know the usual request Thanks)
Maybe it's worth adding something to the effect that copying and pasting cells from outside the striping will override the striping for those cells. Also, this method doesn't work if you hide rows (or use AutoFilter), as the ROW() function relates to the absolute row number, not the on-screen row count. That is, if you hide one row, you'll get 2 rows of the same colour showing.
Maybe it's worth adding something to the effect that copying and pasting cells from outside the striping will override the striping for those cells. Also, this method doesn't work if you hide rows (or use AutoFilter), as the ROW() function relates to the absolute row number, not the on-screen row count. That is, if you hide one row, you'll get 2 rows of the same colour showing.
OK. That's interessant. I'll add a note concerning these problems.
I today needed to change the color on every third row, so I extrapolated from Jacqueline's great article based on yoxi's tip, and I added a new section to the article to cover it ("Every nth Row"). I added a little bit more explanation of what the MOD function is doing, too, to help people understand how to extrapolate to other values of n.
I also added the section to the French version of the article, in Franglish; part of it is a direct copy of Jacqueline's French, and parts that were completely new remains in English. It would be nice if we could render those English parts into French as we have the time.
(I love that article; someone once asked me how to do some other kind of conditional formatting for them in Excel, and I couldn't figure it out from Excel's help, so I loaded the wiki, read Jacqueline and yoxi's instructions, and got things working in Excel. )
Smokey _________________ "[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum
Thanks)
)