Welcome to the Apple iPad Forum, your one stop source for all things iPad. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!
See my answer to your duplicate post here:I have a spreadsheet originally created in Excel and updated variously in Excel (at work) and Open Office/LibreOffice (at home) transported baxk and forth on thumb drive. Now my office has converted to Windows 7 and locked down thumb drives. That's fine; it's their system. So I figure the thing to do is keep my spreadsheet on my iPad 1 (I love my iPad). So what I ultimately need is formulae (for various averages) and color for various ranges of data. I'll also need to print to take the spreadsheet to my doctor. I'm currently running XP Professional on my PC but am saving for and seriously considering a Mac of some flavor for my next PC. So which of all the products mentioned in various posts here will give me what I need on the iPad and for conversion to PC/Mac without loss of data or "special effects"? Thanks! newt0nsbump
Apparently not all rules, and not alwaysThe only automatic color formatting available in Numbers (on the iPad) is the ability to represent negative numbers in red. The Mac OS X version is more powerful and can set conditional rules for text or cell formatting; but they will be stripped when imported to the iPad.