1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • Hello! I'm a newbie to this forum from Adelaide, South Australia.

    From ron.hume@21:1/5 to All on Mon Jan 4 15:30:56 2021
    I have a budget worksheet using Excel 2013 15.0.5301.1000 32 bit.
    The left column contains fortnightly dates, each date row has income,
    expenses and a balance.
    I highlight the current date row with a colour fill manually, but I want
    to fill the row of the next date automatically as the current date
    changes.
    Can someone give me a step by step way to do that or at least give me a
    clue?
    I imagine the IF thing may be useful to compare dates.




    --
    ron.hume

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claus Busch@21:1/5 to All on Mon Feb 1 16:36:09 2021
    Hi Ron,

    Am Mon, 4 Jan 2021 15:30:56 +0000 schrieb ron.hume:

    I have a budget worksheet using Excel 2013 15.0.5301.1000 32 bit.
    The left column contains fortnightly dates, each date row has income, expenses and a balance.
    I highlight the current date row with a colour fill manually, but I want
    to fill the row of the next date automatically as the current date
    changes.
    Can someone give me a step by step way to do that or at least give me a
    clue?
    I imagine the IF thing may be useful to compare dates.

    select your table from A1 to D and the end => Conditional Formatting =>
    and enter there the formula:
    =ROW()=MATCH(TODAY(),$A$1:$A$500,1)+1
    and choose the expected interior color.


    Regards
    Claus B.
    --
    Windows10
    Microsoft 365 for business

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