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

  • Conditional formatting to highlight row after 30 days of invoice date

    From Collin Moore@21:1/5 to All on Sat Jun 3 08:03:43 2023
    I need a formula to highlight the row in red after 30 days based on the invoice date put into that row's C cell.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Alberico Minucci@21:1/5 to All on Tue Jun 13 01:26:26 2023
    Il giorno sabato 3 giugno 2023 alle 17:03:45 UTC+2 Collin Moore ha scritto:

    I need a formula to highlight the row in red after 30 days based on the invoice date put into that row's C cell.

    Use case: invoice date in A1, other info in cells B1, C1, D1
    Select range B1:D1
    Home > Conditional Formatting > New Rule
    Choose "Use a formula to determine which cells to format"
    In the "Format values where this formula is true" field type:
    =NOW()-A1>30
    Then select "Format..." button and select color red in the fill section.
    Done!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Alberico Minucci@21:1/5 to All on Tue Jun 13 01:29:31 2023
    Il giorno martedì 13 giugno 2023 alle 10:26:28 UTC+2 Alberico Minucci ha scritto:

    Ops, this is the correct formula if you want to copy the same format in below rows:

    =NOW()-$A1>30

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