Highlight row based on next date in table

[kgpetersen]

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

 

[NBVC]

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.