• Conditional formatting based on another cell

    Hi, Let's say I have a simple tracker as follows:   Column A: Task Column B: Completion Date Column C: % Completion   I want The entire row to get highlighted in green if I enter 100% in column C. I know...view more
    kshastry
    created by kshastry
  • AppleScript for Numbers

    Hello,   I've got an AppleScript which helps me generate a price list. Everything is working just fine but since an update it behaves a little different.   When I started using the script it was very fast ...view more
    SGIII
    last modified by SGIII
  • A Matrix using Index & Match from two separate tables

    Hi All,   I have an interesting little challenge - I haven't come across anything quite like this before - Hoping that someone in the community has had a similar dilemma and maybe able to help.   Attemptin...view more
    Wayne Contello
    last modified by Wayne Contello
  • Formula help: count the number of blanks in a column "until..."

    name string metric matthew 5 mark 1 mark optimusPrime mark   luke 2 matthew jamesLikesSteak john 3 luke lukingGood matthew luke john johnnyPop john   Hey guys--so I'm dealing with a bit of a...view more
    t quinn
    last modified by t quinn
  • Why Won't This Forum Advance Past Page 1

    Looking for a post I made about Numbers several days ago.  Forum will not advance past page 1; just keeps loading with no progress.  Looked for a button to find my previous posts but no luck.view more
    johnfromplattsmouth
    last modified by johnfromplattsmouth
  • Numbers Crashing on Sierra

    I'm running Numbers 3.6.2 on macOS Sierra Build 16A304a (Public Beta 6) on a mid-2010 MacBook 2.4GHz Core 2 Duo with 8GB RAM.   I have an Expenses spreadsheet where, as the name suggests, allows me to input all ...view more
    Csound1
    last modified by Csound1
  • Once a certain number is reached in tally -drop to zero

    I have a column with each row successively larger as each row contains the tally of the row above it plus a new figure. HOWEVER, once the tally comes to a certain number (found in a separate cell) I want all further r...view more
    Brian Entz
    last modified by Brian Entz
  • Can I print each table on a new page?

    When using Numbers, I often have multiple tables within any given sheet. Like this:     When I print the sheet, this often causes tables to be split onto multiple pages. Like this:     It's v...view more
    momogabi
    last modified by momogabi
  • Colour Tabs or sheet titles in numbers

    How do you Colour Tabs or sheet titles in numbers?view more
    t quinn
    last modified by t quinn
  • Want to auto populate a popup menu

    Hi! I'm looking for a way to auto populate a popup menu with data from a column on a separate sheet. On Sheet 1 I have a bunch of products names listed in column A (with their prices and taxes in columns B onwards.). ...view more
    t quinn
    last modified by t quinn
  • Maximum number of simultaneous filters

    Hi,   I've found out that when reaching 8 different filters on a spreadsheet, the option to add a new filter gets greyed out.   Is there a possibility to increase that number?   Thank you.view more
    sqwal
    last modified by sqwal
  • option command v dosent work

    So at first it did work then it made my text size so mucho bigger and then it just didn't work! HELPview more
    t quinn
    last modified by t quinn
  • numbers column recall

    Hi,   I'm using numbers v3.6.1.   We have a database of all equipment we own with rows stating the make, model number, serial number, description price per day and so on.   What I want to be able ...view more
    DaishunJ
    last modified by DaishunJ
  • How can I order by alphabet the list created on a dropdown menu?

    How can I order by alphabet the list created on a dropdown menu?view more
    t quinn
    last modified by t quinn
  • COUNTIFS specific year

    Hi,   I'm having difficulty coming up with a formula that works, so I'm turning to the community for help. I'm not sure if it's my formula, or if it's possibly a data formatting issue, but I have a flight log, a...view more
    t quinn
    last modified by t quinn
  • Conditional Formatting Rules Not Working

    I have OSX 10.10.5 and Numbers 3.6.1.   I have been working with spreadsheets that use conditional formatting rules to apply a colored fill to cells. True values are filled green and False values are filled red....view more
    MickCharles
    last modified by MickCharles
  • Getting Stock Quotes Into iWork 3.1

    A few months back I was scouring this community for instructions on how to get stock information into iWork.   Folks like Yan Koenig and Bob H. posted some suggestions and I think I was this close to success whe...view more
    crashmeister
    last modified by crashmeister
  • Entering transactions in Numbers

    Hello,   I am very new to numbers and making a budget. I am using a budget template found on Numbers on my ipad. So far I have filled out the budget sheet (entered my own expence categories and expences and budg...view more
    Christopher Joel
    created by Christopher Joel
  • Numbers formula help using date ranges

    I hope I can explain what I am needing well enough to make sense. I have two charts.   One is used to track job bids in the form of money, dates, total awarded and so forth. This chart contains a date column (Co...view more
    t quinn
    last modified by t quinn
  • MS Excel and Mac Numbers

    Thoroughly confused new guy here.  Run an Excel spreadsheet (2013) on Windows 7 and just bought a new MacBook Air 13 with Numbers.  Discovered my MacBook can "read" my Excel spreadsheet downloaded on USB dri...view more
    notcloudy
    last modified by notcloudy