conditional cell formatting
Geoff Sullivan via gnumeric-list <[email protected]> Wed, 15 Jun 2022 09:52:08 -0400
| Newsgroups | gmane.comp.gnome.apps.gnumeric |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format.
--===============7225047159021424851==
Content-Type: multipart/alternative;
boundary="------------dv5T9cSGyXr5ziwMFZCBqA41"
Content-Language: en-US
This is a multi-part message in MIME format.
--------------dv5T9cSGyXr5ziwMFZCBqA41
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
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
--
*Save Buzzards Bay!
<https://secure2.convio.net/bbay/site/TR/Events/General?px=1057434&pg=personal&fr_id=1290>*
▪ BlackLivesMatter!
Sent through the world wide interweb pipes from my solar powered
LinuxMint machine!
--------------dv5T9cSGyXr5ziwMFZCBqA41
Content-Type: multipart/related;
boundary="------------BjrWqSBzUxJjMT5URqkyA6RV"
--------------BjrWqSBzUxJjMT5URqkyA6RV
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>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.</p>
<p>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.</p>
<p>Does anyone know what I'm missing here?</p>
<p>TIA<br>
</p>
<p>-- <br>
</p>
<div class="moz-signature"><b><a
href="https://secure2.convio.net/bbay/site/TR/Events/General?px=1057434&pg=personal&fr_id=1290">Save
Buzzards Bay!</a></b><br>
▪ BlackLivesMatter!<br>
<p> <img src="cid:[email protected]" alt=""
moz-do-not-send="false" width="40" height="27"><br>
</p>
<p>Sent through the world wide interweb pipes from my solar
powered LinuxMint machine!<br>
</p>
</div>
</body>
</html>
--------------BjrWqSBzUxJjMT5URqkyA6RV
Content-Type: image/png; name="136017b7.png"
Content-Disposition: inline; filename="136017b7.png"
Content-Id: <[email protected]>
Content-Transfer-Encoding: base64
iVBORw0KGgoAAAANSUhEUgAAAZUAAAEOBAMAAACz1JeIAAAABGdBTUEAALGPC/xhBQAAACBj
SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAAFVBMVEUAW7sAWb47
d4/EuSv/1wD/1QD///9sYQMaAAAAAWJLR0QGYWa4fQAAANdJREFUeNrtz0ENwgAQAMGTAA5I
FZBgoA8E9FP/VrDAc3OZcTAzAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD87bnGY441XvNZ
4z3fNc6517hcklyaXJpcmlyaXJpcmlyaXJpcmlyaXJpcmlyaXJpcmlyaXJpcmlyaXJpcmlya
XJpcmlyaXJpcmlyaXJpcmlyaXJpcmlyaXJpcmlyaXJpcmlyaXJpcmlyaXJpcmlyaXJpcmlya
XJpcmlyaXJpcmlyaXJpcmlyaXJpcmlyaXJpcmlyaXJquH3quirw/Cw0jAAAAJXRFWHRkYXRl
OmNyZWF0ZQAyMDIwLTAyLTI3VDEwOjMyOjU3LTA1OjAwPTV8PgAAACV0RVh0ZGF0ZTptb2Rp
ZnkAMjAyMC0wMi0yN1QxMDozMjo1Ny0wNTowMExoxIIAAAAASUVORK5CYII=
--------------BjrWqSBzUxJjMT5URqkyA6RV--
--------------dv5T9cSGyXr5ziwMFZCBqA41--
--===============7225047159021424851==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
--===============7225047159021424851==--