4 Replies Latest reply: Nov 19, 2012 6:29 AM by ronenhaim
ronenhaim Level 1 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 ?

 

Thanks


iMac, OS X Mountain Lion, 10.8.2
  • Barry Level 7 Level 7 (29,210 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.

     

    Regards,

    Barry

  • ronenhaim Level 1 Level 1 (20 points)

    Thank you.

     

    I understand  your answer .

     

    I use to see my dates as follows :

     

    31/7/2013


    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 )

     

    Thanks

     

  • Barry Level 7 Level 7 (29,210 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.

     

    Regards,

    Barry

  • ronenhaim Level 1 Level 1 (20 points)

    Thank you very much for your help .

    Best regards,

    Ronen