I have a Numbers spreadsheet where I would like to shade the rows depending on the values (even/odd) in my second (B) column.
I've been all over the forum, but I can't seem to find a script that matches, and I cannot edit one and make it work.
Anyone with a template and a few kind words? :-)
Mac mini (Late 2014), OS X El Capitan (10.11.6)
Hi jsteinaa,
Here is a method that does not require Applescript.
Add another column, C. You can hide that column later.
Formula in C2 (and Fill Down)
=IF(ISEVEN(B2),B2,"")
If a value in B is even, make the cell in C equal to the B cell, else insert "" (NULL).
Conditional highlighting in B
Alternative: use the ISODD function in C.
Please call back with questions.
Regards,
Ian.
Hi Ian - thanks a bunch for your reply.
I have both text and numbers and dates in my sheet, so the comparison doesn't quite do it. Quite a nice "workaround" though for other situations.
Hi jsteinaa,
I have both text and numbers and dates in my sheet
Perhaps a screen shot of a small part of your table will help us to help you.
Regards,
Ian.
Great idea :-)
This is basically it. I want to highlight rows based on the "Day" (even/odd).
Using Applescript for formatting rows in Numbers
