iseven(row()) works fine. Hope this helps, Jean
Le mercredi 15 juin 2022 à 09:52 -0400, Geoff Sullivan via gnumeric- list a écrit : > I want to figure out how to add color to alternate rows of a > spreadsheet using conditional formatting. In LibreOffice Calc there > is a way to do this by setting the conditional of a range of cells to > '=iseven(row())' and defining a style color in the dialog. Voila! > alternate rows appear in the chosen color. > In Gnumeric there is an option for conditional formatting that seems > to allow for the same effect. Select a range of cells to apply the > row colors to. Under Format > Cells > Conditional Formatting there is > a dialog box. You select 'Selection evaluates to TRUE' in the first > box, enter (I think) '=iseven(row))' in the 'x:' box, select a > background in the style box, and close. The colored rows should > appear in your spreadsheet now. NOT SO MUCH. I tried this several > different ways and once I noticed the Add button lit beside the box > on the left (Editing conditional formatting:) and I clicked it. I > believe some confirmation should have appeared there but it didn't. > Does anyone know what I'm missing here? > TIA > _______________________________________________ > gnumeric-list mailing list > gnumeric-list@gnome.org > https://mail.gnome.org/mailman/listinfo/gnumeric-list _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
