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?


  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    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"


    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