jsteinaa

Q: Using Applescript for formatting rows in Numbers

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)

Posted on Sep 19, 2016 1:58 PM

Close

Q: Using Applescript for formatting rows in Numbers

  • All replies
  • Helpful answers

  • by Yellowbox,Helpful

    Yellowbox Yellowbox Sep 20, 2016 6:33 AM in response to jsteinaa
    Level 6 (10,485 points)
    Mac OS X
    Sep 20, 2016 6:33 AM in response to jsteinaa

    Hi jsteinaa,

     

    Here is a method that does not require Applescript.

    Add another column, C. You can hide that column later.

    Screen Shot 2016-09-20 at 8.23.31 PM.png

    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

    Screen Shot 2016-09-20 at 8.28.43 PM.png

    Alternative: use the ISODD function in C.

    Please call back with questions.

     

    Regards,

    Ian.

  • by jsteinaa,

    jsteinaa jsteinaa Sep 20, 2016 6:33 AM in response to Yellowbox
    Level 1 (4 points)
    iWork
    Sep 20, 2016 6:33 AM in response to Yellowbox

    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.

  • by Yellowbox,

    Yellowbox Yellowbox Sep 20, 2016 9:14 AM in response to jsteinaa
    Level 6 (10,485 points)
    Mac OS X
    Sep 20, 2016 9:14 AM in response to jsteinaa

    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.

  • by jsteinaa,

    jsteinaa jsteinaa Sep 20, 2016 11:08 AM in response to Yellowbox
    Level 1 (4 points)
    iWork
    Sep 20, 2016 11:08 AM in response to Yellowbox

    Great idea :-)

     

    Screendump.png

     

    This is basically it. I want to highlight rows based on the "Day" (even/odd).