View original (French)

Highlight a date greater than or equal to 15 days

Solved
skarlet -  
 skarlet -
Hello,

Hello,
I have a table to manage and track my insurance contracts.
I need to have in one column the due date minus 105 days (or 3.5 months) because I must terminate my contracts if needed 3.5 months in advance.
How can I proceed?

I solved this with the help of one of the members, but I have another small question:

Can I enter in this column "date-105 days" a formula that would color my cell for about 15 days?
For example, I have a due date on 31/07, therefore a termination letter on 15 March. How can I make it so that from 15/03 to 30/03, my cell is colored to alert me?

thanks in advance

Configuration: Windows XP / Internet Explorer 8.0

8 answers

  1. skarlet
     
    It works !!!

    Thank you very much for your help
    2
  2. antiarnaqe Posted messages 63 Status Member 1
     
    I could help you, but I didn’t understand your question well?
    0
  3. Morgothal Posted messages 1350 Status Member 184
     
    Hello,
    Following this post I imagine ;-)

    Pijaku has already guided you well!
    To apply such conditional formatting, you must therefore:
    Select the cell containing the date (the one that will be colored according to the condition)
    Conditional formatting > New rule > Use a formula...
    Enter this formula: 
    =ET(cellule_date>=AUJOURDHUI();cellule_date<=AUJOURDHUI()+15)

    And choose the formatting that will apply if this condition is met.

    See you!
    -------------------
    Best regards,
    Clément
    0
  4. skarlet
     
    I’m resuming:

    I have a table to manage and track my insurance contracts.
    I need to have in one column the due date minus 105 days (or 3.5 months) because I must cancel my contracts if needed 3.5 months in advance.

    So I entered a formula =E1-105

    Now I would like to know if it is possible to color or highlight the cell in which I entered this formula for a certain period, about two weeks, to alert me.

    Example, I have a due date on 31/07, so a cancellation letter on 15 March. How can I make it so that from 15/03 to 30/03, my cell is colored to alert me?

    I hope that’s a bit clearer,

    thanks in advance
    0
  6. skarlet
     
    I forgot to specify I am using Excel 2007
    0
  7. Morgothal Posted messages 1350 Status Member 184
     
    I just redid the procedure, it works fine on my end (Excel 2007 too).
    Here is a sample file, in case it can help you ...

    --
    -------------------
    Best regards,
    Clément
    0
  8. skarlet
     
    I followed your example closely but I don’t understand why it isn’t working.
    0
    1. Morgothal Posted messages 1350 Status Member 184
       
      Do you have dates that match the criterion?
      "date_echeance-150
      0
  9. skarlet
     
    Yes, I’m running a simulation, so I’ve entered dates that would meet the criteria.
    0