Numbers sheet & conditional highlighting?

Discussion in 'iPad 2 Forum' started by tonyt, Feb 3, 2015.

  1. tonyt

    tonyt
    Expand Collapse
    iPF Novice

    Joined:
    Jan 9, 2015
    Messages:
    15
    Thanks Received:
    0
    Hi
    I created a sheet on my Mac in Numbers 3.2.2 (on Mavericks). It contained conditional highlighting rules. I got it into Numbers on my iPad Air 2, but no highlighting! Do the rules not move with the sheet?
    Cheers!
    tonyt
     
  2. Gtatler

    Gtatler
    Expand Collapse
    iPad Enthusiast

    Joined:
    Dec 5, 2011
    Messages:
    487
    Thanks Received:
    69
    Don't know if the rules are carried over to numbers, but here is a site with info on conditional formatting. Hope it help you.

    http://support.apple.com/kb/PH14856

    Also Google will give several other sites.

    Sent from my iPad using Tapatalk
     
  3. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    20,422
    Thanks Received:
    6,103
    No, the iPad version of Numbers doesn't have support for conditional highlighting. The most you can do is choose a cell format that will change based on whether the number is negative or positive. There are only a few options.

    I havn't tested this, but the actual formatting probably remains in the file, so that it will still work properly on the Mac.
     
  4. tonyt

    tonyt
    Expand Collapse
    iPF Novice

    Joined:
    Jan 9, 2015
    Messages:
    15
    Thanks Received:
    0
    Many thanks! I thought as much!
     
  5. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    20,422
    Thanks Received:
    6,103
    No problem.
     
  6. SyAn

    SyAn
    Expand Collapse
    iPF Noob

    Joined:
    May 18, 2017
    Messages:
    5
    Thanks Received:
    0
    I have conditional formatting that changes cell colour depending on what date is shown in comparison with a series of dates.
     
  7. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    20,422
    Thanks Received:
    6,103
    If you imported the spreadsheet from the Mac verison of Numbers, some of the extended features may work. Some mahy not. You might even retain a few from a spreadsheet impoted from Excel. Either way, you won't be able to edit those features from the iPad.

    Now, if I'm wrong, and you can create and edit this features from the iPad I really really want to hear about it. I'd love to have conditional formating on the iPad without creating it first on the Mac.
     
  8. SyAn

    SyAn
    Expand Collapse
    iPF Noob

    Joined:
    May 18, 2017
    Messages:
    5
    Thanks Received:
    0
    Sorry, did not express that clearly, iPad can only display, but neither create nor change.
    And if you hear any news re this, I most certainly would love to know too, would be very nice to have that functionality in iPad :)
     
  9. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    20,422
    Thanks Received:
    6,103
    No problem. I was kind of hoping I was wrong.
     

Share This Page



Search tags for this page

apple ipad farmat rule