1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • Conditional formating to highlight dates 30, 60, and 90 days o

    From Patrick Blanc@21:1/5 to All on Tue Feb 2 11:12:40 2021
    Does anyone know how to highlight dates that are older than 30 days?
    For example, today is 2/2/2021.
    If I have the date 1/1/2021 in a cell, I want to use conditional formatting to highlight this date because at least 30 days have passed since 1/1/2021. Can anyone help with this?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claus Busch@21:1/5 to All on Tue Feb 2 20:19:15 2021
    Hi,

    Am Tue, 2 Feb 2021 11:12:40 -0800 (PST) schrieb Patrick Blanc:

    Does anyone know how to highlight dates that are older than 30 days?
    For example, today is 2/2/2021.
    If I have the date 1/1/2021 in a cell, I want to use conditional formatting to highlight this date because at least 30 days have passed since 1/1/2021. Can anyone help with this?

    if your date is in A1 then try in conditional formatting:
    =A1<=Today()-30

    Regards
    Claus B.
    --
    Windows10
    Microsoft 365 for business

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From shreyasi prasad@21:1/5 to claus...@t-online.de on Mon Jan 9 23:03:34 2023
    On Wednesday, February 3, 2021 at 12:49:18 AM UTC+5:30, claus...@t-online.de wrote:
    Hi,
    Am Tue, 2 Feb 2021 11:12:40 -0800 (PST) schrieb Patrick Blanc:

    Does anyone know how to highlight dates that are older than 30 days?
    For example, today is 2/2/2021.
    If I have the date 1/1/2021 in a cell, I want to use conditional formatting to highlight this date because at least 30 days have passed since 1/1/2021. Can anyone help with this?
    if your date is in A1 then try in conditional formatting:
    =A1<=Today()-30

    Regards
    Claus B.
    --
    Windows10
    Microsoft 365 for business


    Hi all,

    I have a situation where, A=follow UP, Invite Sent, B= Last contacted Date, I need to highlight the cell in B which is more than/ above
    1. 30 days,
    2. 60 days,
    3. 90 days,
    4. 15 days,
    5. 3 days.

    What formula could be used in each case. to assign different colors in cell B

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)