Highlight Rows If Dates Have Passed

This post will guide you how highlight rows if the dates in cells have passed from now in your worksheet. How do I highlight rows if dates have passed with the Conditional Formatting feature in excel.

Highlight Rows If Dates Have Passed

Assuming that you have a worksheet that have a bunch of columns and each row has a date column. If the date in the date column goes past from now on and you want to highlight the entire row with red color. How to achieve it. And you need to use the Conditional Formatting feature to highlight all rows that if the dates have passed from now on.

So you need to do the following steps:

#1 select the table that you want to highlight rows if the dates have passed.

higlight rows if date passed1

#2 go to HOME tab, click Conditional Formatting command under Styles group, and then click New Rule… from the drop down list. The New Formatting Rule dialog will appear.

higlight rows if date passed2

#3 select Use a formula to determine which cells to format in the list box of Select a rule type, and type this formula: =$B1<TODAY() into the text box of the Formula values where this formula is true box.

higlight rows if date passed3

#4 click Format button, switch Fill tab, select the red color, then click OK button.

higlight rows if date passed4

#5 let’s see the result.

higlight rows if date passed5

You will see that all rows have been highlighted with red color if the dates have passed from now in your selected range of cells.

Related Functions

  • Excel TODAY function
    The Excel TODAY function returns the serial number of the current date. So you can get the current system date from the TODAY function. The syntax of the TODAY function is as below:=TODAY()…