Skip navigation

Add "rule" to a table cell

238 Views 4 Replies Latest reply: Nov 19, 2012 6:29 AM by ronenhaim RSS
ronenhaim Level 1 Level 1 (10 points)
Currently Being Moderated
Nov 17, 2012 3:04 AM

Is it possible to make a cell rule as follows :

 

I have a cell with date : 31/7/2013

I want to make this cell in orange background 15 days before 31/7/2013 = 16/7/2013

And change the background color again to red 2 days before 31/7/2013 = 29/7/2013

 

Is it possible ?

 

Thanks

iMac, OS X Mountain Lion, 10.8.2
  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Nov 18, 2012 12:14 AM (in response to ronenhaim)

    HI Ronen,

     

    Use Conditional Formatting with several rules. Here's an example showing the rules applied to a series of dates before and after today (November 18, 2012):

    Picture 11.png

    Numbers reads the rules from top to bottom, and formats according to the first one that is TRUE.

     

    Regards,

    Barry

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Nov 18, 2012 10:45 AM (in response to ronenhaim)

    Numbers takes its 'all numeral' date format from the setting in System Preferences.

     

    The setting is found in the Formats section of the International pane. If your preferred setting is available in one of the "Region" sets, use that.

     

    Mine isn't, so as you'll see in the image below, I use a "Custom" region, as none of the pre-set regions fit (all) the formats I prefer.

    Picture 12.png

    Numbers doesn't handle this too well; it often flips the day and month when I change the format on an individual cell from 'Automatic" to Date and Time (eg. Jan 5, 2012 will change to May 1, 2012 if I re-format the cell), so I tend to avoid the 'all numeral' format where I can.

     

    Regards,

    Barry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.