Home » Posts

Highlight dates between

If you want to highlight dates between two dates with conditional formatting, you can use a simple formula that uses the AND and DATE functions together. For example, if you have dates in the range B4:G11, and want to highlight cells that contain a date greater than August 1st, 2015, and less than November 1, 2015, select the range and create a new CF rule that uses this formula: =AND(B4>=DATE(2015,8,1),B4=) and less than or equal to (

April 14, 2025 · 1 min · 66 words · Ryan Burns

Table of Contents

Explanation

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

The DATE function creates a proper Excel date with given year, month, and day values.

Use other cells for input

You don’t need to hard-code the dates into the rule.

Excel formula: Highlight dates greater than

AND returns TRUEonly if all the conditions are met.

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

Excel DATE function

Excel AND function

Explanation#

Use other cells for input#

Explanation

Use other cells for input