How to Highlight Dates between Two Dates in Excel

This post will guide you how to highlight dates between two dates in your worksheet in Excel. How do I highlight cells between two dates using Conditional Formatting feature in Excel 2013.2016.

Highlight Dates between Two Dates


Assuming that you have a list of data in range B1:B6, in which contain date values. and you want to highlight all the dates which are between the range of two dates. such as: you have a start date 2019/8/21 and an end date 2019/12/31, and you want to highlight all the cells in which date is between these two dates. just do the following steps:

Step1: select you range of cells that you want to highlight the date cells.

highlight dates between two dates1

Step2: go to Home tab, and click Conditional Formatting command under Styles group, and select new Rule from the context menu list. and the New Formatting Rule dialog will open.

highlight dates between two dates2

Step3: click Use a formula to determine which cells to format option in the Select a Rule Type list, and type the following formula into the Format values where this formula is true text box.

=AND($B1>=$E$1,$B1<=$E$1)

highlight dates between two dates3

Step4: click Format button in the New Formatting Rule dialog box, and the Format Cell dialog will open.

Step5: switch to Fill tab in the Format Cell dialog box, and choose one color as you need. click Ok button back to the New Formatting Rule dialog box.

highlight dates between two dates4

Step6: click Ok button. You would see that the cells have been highlighted.

highlight dates between two dates5

 

 

 

 

 

 

 

Related Posts

Match Single Criteria in Excel

No repeat statistic based on a single condition is used wildly in daily work, for example, count type of products, the duplicate types are not encountered. This article describes the way of no repeats statistics for data in a single ...

Excel Array Construction

This article will talk about how to create one-dimensional array or two-dimensional array by using some functions in Excel. When using array formulas in Excel, we often use functions to construct arrays. Generate Array with ROW or COLUMN Functions Array ...

Excel Array Operation

We have all heard of arrays. Depending on the dimensionality, they are divided into one-dimensional arrays and two-dimensional arrays. Depending on the data type, they can also be divided into numeric arrays, logical arrays, and so on. The concatenation and ...

Excel Array Matrix Operation

In Excel, we have a built-in function used to perform matrix operations. It is the MMULT function. This function accepts two arrays as parameters and returns the product of the two arrays. However, this function has a prerequisite that the ...

A1 Reference Style and R1C2 Reference in Excel

In Excel, there are two reference styles. A1 reference style and R1C2 reference style. These two reference styles can help us find the cell by the cell address. Some functions return these two addresses through the argument settings. A1 Reference ...

Comments

So empty here ... leave a comment!

Leave a Reply

Sidebar