View original (French)

Color cells by date

CygneTranquille18 Posted messages 1 Registration date   Status Member Last intervention   -  
blackmefias_3350 Posted messages 716 Registration date   Status Member Last intervention   -
Hello everyone,

I have an invoice reminder table. I would like, relative to today's date,
- invoices of less than 8 days to be colored GREEN,
- invoices between 9 and 15 days to be colored ORANGE,
- invoices between 16 and 21 days to be colored RED,
- invoices between 22 and 30 days to be colored VIOLET.

A BIG THANK YOU to everyone who can help.

Best regards,
Daniel

2 answers

  1.
    danielc0 Posted messages 2220 Registration date   Status Member Last intervention   294
     
    Hello,

    Could you share the workbook with confidential data anonymized?

    To share it, click on:

    https://www.swisstransfer.com/fr-fr

    Click on "Click to add your files." Make sure the "Link" button is green; if not, click it. Click "Transfer." Solve the "I'm not a robot" captcha. Copy the displayed link and paste it in your reply.

    Daniel
    0
  2. blackmefias_3350 Posted messages 716 Registration date   Status Member Last intervention   69
     

    Conditional formatting must be used.

    formulas to apply (one per formatting, so you will have 4 formats for the 4 colors):

    For green:

    =TODAY()-$A2<=8

    Orange:

    =AND(TODAY()-$A2 >= 9; TODAY() - $A2 <= 15)

    Red:

    =AND(TODAY()-$A2 >= 16; TODAY()-$A2 <= 21)

    Purple:

    =AND(TODAY()-$A2 >= 22; TODAY()-$A2 <= 30)

    0