4 Replies Latest reply: Nov 19, 2012 6:29 AM by rony-z
rony-z Level 1 (20 points)

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 ?



iMac, OS X Mountain Lion, 10.8.2
  • Barry Level 7 (29,990 points)

    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.




  • rony-z Level 1 (20 points)

    Thank you.


    I understand  your answer .


    I use to see my dates as follows :



    meaning : 31 of July 2013.



    1. Is Numbers can " see "  this format as a TRUE date ?


    If not , How can I change all dates to a TRUE formats when filing them into a cell ?


    Meaning : When filling date , an automatic true format will be , instead of my false format ( Auto correction )




  • Barry Level 7 (29,990 points)

    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.




  • rony-z Level 1 (20 points)

    Thank you very much for your help .

    Best regards,