Results 1 to 2 of 2

Thread: Highlight row based on next date in table

  1. #1

    Highlight row based on next date in table



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All.
    I'm fairly new to Excel.
    I'm trying to determine the next upcoming date in a table and highlight that cell's entire row.
    Is anybody able to help me accomplish this?

    Cheers,
    kp

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,436
    Articles
    0
    Excel Version
    Excel 2016
    Assuming the dates are in B2:B43, select all cells in the range from row 2 to 43, then go to Home|Conditional Formatting|New. Select "use a formula to determine which cells to format", then enter formula"

    =$B2=MIN(IF($B$2:$B$43>TODAY(),$B$2:$B$43))

    Click Format and then in Fill tab choose your colour. Click Ok, then Ok again to apply.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •