Highlight rows with dates between

If you want to highlight rows that contain dates between two dates with conditional formatting, you can use a formula based on the AND and DATE functions. In the example, shown, the range B5:E11 has a conditional formatting rule applied using this formula: =AND($C5>=start,$C5

April 14, 2025 · 1 min · 80 words · Laura Logan

Table of Contents

Explanation

The AND function takes multiple arguments and returns TRUE only when all arguments return TRUE.

Dates are just serial numbers in Excel, so earlier dates are always less than later dates.

References to the start and end dates (C2 and E2) are absolute and will not change.

Excel formula: Highlight dates greater than

Itcreates a proper Excel date with given year, month, and day values.

AND returns TRUEonly if all the conditions are met.

If any conditions are not met, the AND function returns FALSE.

Excel formula: Highlight dates between

Excel DATE function

Excel AND function