Thread Conditional formatting based on another cell
Conditional formatting based on another cellHi, 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
AppleScript for NumbersHello, 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
Thread A Matrix using Index & Match from two separate tables
A Matrix using Index & Match from two separate tablesHi 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
Why Won't This Forum Advance Past Page 1Looking 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
Numbers Crashing on SierraI'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
Thread Once a certain number is reached in tally -drop to zero
Once a certain number is reached in tally -drop to zeroI 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
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
Want to auto populate a popup menuHi! 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
Maximum number of simultaneous filtersHi, 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
numbers column recallHi, 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
COUNTIFS specific yearHi, 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
Conditional Formatting Rules Not WorkingI 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
Getting Stock Quotes Into iWork 3.1A 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
Entering transactions in NumbersHello, 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
Numbers formula help using date rangesI 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
MS Excel and Mac NumbersThoroughly 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